Re: how to find linefeeds and cr in char fields

On Wed, 4 Apr 2001 16:30:48 +0200, "Carsten Jacobs" <carsten.jacobs_at_web.de> wrote:

>Hello all,
>
>how can I find linefeeds and carriage returns in a character fields?
>
>select * from text_tab
>where textfield like '% ??? %'
>
>Many thanks for a quick answer!
>
>Carsten
>

select * from text_tab
where instr(textfield,chr(13)) > 0
/
or
select *
from text_tab
where textfield like '%'||chr(13)||'%'

Homework!

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Apr 04 2001 - 16:56:11 CDT