Re: Carriage Returns

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 26 Oct 2001 13:53:08 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA722DA2E@lnewton.leeds.lfs.co.uk>

Unless it contains Unix 'carriage returns', in shich case, use CHR(10) instead.

Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com
------------------------------------------------------------------------

-----Original Message-----
From: Marc Billiet [mailto:first.last_at_com.hydro.switch.this] Posted At: Friday, October 26, 2001 11:50 AM Posted To: server
Conversation: Carriage Returns
Subject: Re: Carriage Returns

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 - 07:53:08 CDT