Substring special characters

[David C]

How do I search for CrLf in a text column? I was thinking of "....WHERE
SUBSTRING(Subfile,1,1) LIKE '%vbCrLf%' but I know that is VB syntax.
Thanks.

David

 

[cfps.Christian]

How do I search for CrLf in a text column? I was thinking of "....WHERE
SUBSTRING(Subfile,1,1) LIKE '%vbCrLf%' but I know that is VB syntax.
Thanks.

David

I would find the SQL group and ask them how you would substring for a
line break in a text column.

 

[bruce barker]

just include it in the search string. in sql no special char is needed as lf
is not a line terminator.

select *
from foo
where myColumn like '%
%'


-- bruce (sqlwork.com)