Substring special characters

[David C]

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

David

[cfps.Christian]

Re: Substring special characters

On May 5, 11:35 am, "David C" <dlch...@lifeti meinc.comwrote:

How do I search for CrLf in a text column? I was thinking of "....WHERE
SUBSTRING(Subfi le,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.

[=?Utf-8?B?YnJ1Y2UgYmFya2Vy?=]

RE: Substring special characters

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)


"David C" wrote:

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