when i used escape sequence characters in stored procedure, it display normal text on screen. like Dummy test. i need to display data return or show by sql in new line character e.g
Dummy
Test

when i used new line character '\n' it display text as it is.

I am using: Print 'Dummy \n Text'
output: Dummy \n Text
Desired result: Dummy
                Text



thanks......

__________________
thanks......

Where are you trying to display this data? What is consuming it?

-Peter
compiledthoughts.com

\n is *NOT* anything special to T-SQL (SQL Server's dialect of SQL).

That is, the string '\n' is just the two characters \ and n.

\n means "newline" in C# and Java and JavaScript, etc., but *NOT* in T-SQL.

Instead of
     Print 'Dummy \n Text'
try
      Print 'Dummy ' + CHAR(10) + 'Text'
or even
      Print 'Dummy ' + CHAR(13) + CHAR(10) + 'Text'

http://msdn.microsoft.com/en-us/library/aa258239(SQL.80).aspx

Dang, Pedant... nice to see someone who still remembers that "old" stuff like me. You even put the CrLf in the correct order so as not to accidently strike a character in the middle of a page on an old 110 baud Tele-Type. ;)

--Jeff Moden

No, no...you had to use CR+CR+LF on some of those machines. They would get worn out and dirty and were sluggish doing the RETURN so you needed a little extra time to be sure.

(Actually, I started out on model 35, which was even more bizarre. Had a removable font plate, so you could install different character sets.
http://portal.acm.org/citation.cfm?id=987461.987466
is one example. Our use was more exotic.)

Heh... I remember that having to double up like that. Fun times...

--Jeff Moden