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_at_y1032696.hae.hydro.com>
Date: Fri, 26 Oct 2001 10:49:54 GMT
Message-ID: <20011026.10495464_at_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 - 12:49:54 CEST