Suppose I have a varchar column, in which the following is stored:

The brown
fox jumped over
the tall
fence

Each line is separated via a hard carriage return. How is that carraige return stored in the varchar column? What do i look for to find that carriage return?


Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

__________________
========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the Windows Communication Foundation
Professional LINQ
========================

They can be stored several ways... CrLf (Carriage Return & Line Feed), just Cr, or just Lf (we won't talk about vertical tabs, here). Here's how you can represent each one of those characters in SQL (and several other languages, to boot!)...

Cr = CHAR(13)
Lf = CHAR(10)
CrLf = CHAR(13)+CHAR(10)

--Jeff Moden

Thanks Jeff. That took me in the right direction...

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

You bet... thank you for the feedback.

--Jeff Moden