Re: sql statement to find carriage return
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 17 Dec 2003 14:51:41 -0800
Message-ID: <1071701407.299559_at_yasure>
>
>
> select <whatever you want>
> from <your table>
> where instr(<column you want to check>, chr(13)) != 0 /* DOS character */
> or instr(<column you want to check>, chr(10)) != 0 /* carriage-return */
>
> Only works with charactersets which are ASCII supersets.
Date: Wed, 17 Dec 2003 14:51:41 -0800
Message-ID: <1071701407.299559_at_yasure>
Alex Filonov wrote:
> "Bill Thomason" <billthomason_at_charter.net> wrote in message news:<vtur8v91iqmi93@corp.supernews.com>...
>
[Quoted] >>I am looking for a simple sql statement to find carriage returns in our data >>that has been loaded. >> >>Bill
>
>
> select <whatever you want>
> from <your table>
> where instr(<column you want to check>, chr(13)) != 0 /* DOS character */
> or instr(<column you want to check>, chr(10)) != 0 /* carriage-return */
>
> Only works with charactersets which are ASCII supersets.
You are assuming the field is a CHAR or VARCHAR2. That is only an assumption as the OP never stated the data type. It could be a LONG or a CLOB: We just don't know.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Dec 17 2003 - 23:51:41 CET