how to find linefeeds and cr in char fields

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 Received on Wed Apr 04 2001 - 09:30:48 CDT