Re: how to find linefeeds and cr in char fields

hi,

Carsten Jacobs 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 textfield LIKE '%' || CHR( 10 ) || '%'

    OR textfield LIKE '%' || CHR( 13 ) || '%';

-- 
Andreas Necker

ISB AG              Tel: +49 (0)721/82800-0
Karlstrasse 52-54   Fax: +49 (0)721/82800-82
76133 Karlsruhe     mailto:Andreas.Necker_at_isb-ag.de
Germany             http://www.isb-ag.de