From: "Carsten Jacobs" <carsten.jacobs@web.de>
Newsgroups: comp.databases.oracle.misc
Subject: how to find linefeeds and cr in char fields
Date: Wed, 4 Apr 2001 16:30:48 +0200
Lines: 12
Message-ID: <9afb6p$4n7on$1@ID-21443.news.dfncis.de>
NNTP-Posting-Host: 195.127.105.1
X-Trace: fu-berlin.de 986394649 4955927 195.127.105.1 (16 [21443])
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400


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