>Yes, exactly. The last approach will work. I remember long time ago (in 2003) I had the same frustration when I tried to use Raiserror the first time. Now I know about its "limitations" and either construct the whole string as a variable or embed values using parameters as BOL states. It would be nice to have a simpler syntax in future versions of SQL Server.
Thanks