Re: sql statement to find carriage return

Thanks Alex,
I appreciate the courtesy of not being talked down to. I am not a dba and don't claim to be but i just had a question i was having a problem finding an answer to without getting bunch of crap for being stupid.

"Alex Filonov" <afilonov_at_yahoo.com> wrote in message news:336da121.0312171106.3775c4e8_at_posting.google.com...
> "Bill Thomason" <billthomason_at_charter.net> wrote in message
news:<vtur8v91iqmi93_at_corp.supernews.com>...
> > 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.
Received on Thu Dec 18 2003 - 15:50:37 CET