Prev: T-SQL cursor - Variables in an email body
Next: Check constraint with a scalar UDF not working
From: Plamen Ratchev on 13 Apr 2010 18:17
You have to use nested REPLACE function calls:

SET @pbody = REPLACE(REPLACE(REPLACE(REPLACE(@email_body, '{0}', @Operator),
'{1}', @Vehicle),
'{2}', @PM_letter),
'{3}', @PM_desc);

--
Plamen Ratchev
http://www.SQLStudio.com
 | 
Pages: 1
Prev: T-SQL cursor - Variables in an email body
Next: Check constraint with a scalar UDF not working