Finding carriage return in a string

[Rickspx]

Hi,

I want to find out the carriage return in a string.
I tried \n and \r but that doesn't seem to work
Can somebody help

Thanks
Rick

 

[tlbroadbent]

CR = char(13)
LF = char(10)

CRLF = char(13)+char(10) If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[billum]

Thanks Terry
I used that !!