Re: Carriage Returns

From: Marc Billiet <first.last_at_com.hydro.switch.this>
Date: Fri, 26 Oct 2001 10:49:54 GMT
Message-ID: <20011026.10495464@y1032696.hae.hydro.com>

Op 26/10/2001, 12:02:26, schreef "Allan Martin" <allan.martin_at_saic.com> over het thema Carriage Returns:

> Hi,
> I have some data in a column that has some carriage returns tailing on
the
> end of the data. How can I run a query that will find any carriage
returns
> in the data?

> Thank a lot,
> Allan

Try something like:

select *
from your_table
where instr(your_column, chr(13)) <> 0

Marc Received on Fri Oct 26 2001 - 05:49:54 CDT