Line Feed Characters in String Insert

[Chubby]

Hi,

Can anyone help with how to insert a line feed character in s string in a Stored Procedure ? Using Char(10) or Char(13) doesnt seem to want to work.

Thanks

Chubby..

[brucevde]

Maybe post your code and explaining what "doesnt seem to want to work." would help.

Declare @Temp varchar(50)

set @Temp = 'Hello' + char(10) + 'World'

Print @Temp