INSTR to find (CHR13) Carriage Returns

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