newline character

I want to append a newline character to a string.
what is a new-line character in SQL Server 2000?
Can someone help me.
Thank You.select 'gola' + char(13) + 'Munjal'
try this
cheers
gola

Originally posted by swatisk
I want to append a newline character to a string.
what is a new-line character in SQL Server 2000?

Can someone help me.
Thank You.|||thanx for ur help..

Originally posted by golamunjal
select 'gola' + char(13) + 'Munjal'
try this
cheers
gola