Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> INSTR to find (CHR13) Carriage Returns

INSTR to find (CHR13) Carriage Returns

From: <NeedaHoliday>
Date: Tue, 04 Jan 2000 20:22:29 GMT
Message-ID: <387255e1.25434176@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 - 14:22:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US