From: Sybrand Bakker <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.misc
Subject: Re: how to find linefeeds and cr in char fields
Date: Wed, 04 Apr 2001 23:56:11 +0200
Message-ID: <g06nct45r8n67p9l4gl6bjs324nkcmdm6n@4ax.com>
Reply-To: postbus@sybrandb.demon-verwijderdit.nl
References: <9afb6p$4n7on$1@ID-21443.news.dfncis.de>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@nl.demon.net
NNTP-Posting-Host: sybrandb.demon.nl
X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78
X-Trace: beta-news.demon.nl 986421244 beta-news:87479 NO-IDENT sybrandb.demon.nl:212.238.21.78
Lines: 29


On Wed, 4 Apr 2001 16:30:48 +0200, "Carsten Jacobs"
<carsten.jacobs@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