Formatting strings with placeholders in SQL Server like in C#

Question

I need to store generic messages in an SQL Server table, and then get the values and use them within a stored procedure, e.g. "Dear John", where instead of "John" I would like to be able to insert any name obtained within the procedure. In C#, if I stored the text like this: "Dear {0}", I could then easily format it: string.Format(myString, name). Can I do anything like this in SQL Server, other than just REPLACE? I heard something like using CLR in SQL Server, but have no idea whether or how it would work. What is the best way to achieve what I need?

Could you please help?

Thanks.

What version of SQL Server?

gbn
– gbn

2013-06-05 14:59:11 +00:00
Commented Jun 5, 2013 at 14:59 — gbn
– gbn, Commented Jun 5, 2013 at 14:59

StaWho · Accepted Answer · 2013-06-05 15:05:46Z

2

xp_sprintf may be what you're looking for :

DECLARE @ret_string varchar (255)
EXEC Master.DBO.xp_sprintf @ret_string OUTPUT, '(%s, %s)', 'Hello', 'World'
PRINT @ret_string

Outputs (Hello, World)

edited Jun 5, 2013 at 15:05

answered Jun 5, 2013 at 14:59

StaWho

2,49817 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Formatting strings with placeholders in SQL Server like in C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related