Format command on SQL

Webbo_1980
Webbo_1980 used Ask the Experts™
on
Is there a way to simulate the string.format command in SQL

e.g.

string.format("([{0}] LIKE '%{1}%')",param1,param2)

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
No. The only functions you have at your disposal for reformatting a string is LEFT, RIGHT, SUBSTRING and REPLACE.

Regards,

Lee

Commented:
additionally you can concatenate strings by + operator.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial