Substring special characters

  • Thread starter Thread starter David C
  • Start date Start date
D

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
 
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
Click to expand...

I would find the SQL group and ask them how you would substring for a
line break in a text column.
 
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)
 
Back
Top