Re: INSTR to find (CHR13) Carriage Returns

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 4 Jan 2000 22:02:09 +0100
Message-ID: <947019815.13880.0.pluto.d4ee154e@news.demon.nl>

Nice alias...

it should be
SELECT INSTR(TxT_FIELD, CHR(13))
from table;

Hth

--
Sybrand Bakker, Oracle DBA
<NeedaHoliday> wrote in message news:387255e1.25434176_at_news.pwgsc.gc.ca...
> I tried the following and did not find a CR in the text field. What am
> I doing wrong.
>
> THanks in advance
>
>
> SELECT INSTR(TxT_FIELD, 'CHR(13)') from table;
>
> It returns 0 and I know there are CR in the text.
>
> Jim
>
> removejames.stewart_at_pwgsc.gc.ca
>
> OMIT REMOVE to email
Received on Tue Jan 04 2000 - 15:02:09 CST