Re: sql statement to find carriage return

[Quoted] "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>
[Quoted] [Quoted] 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 Wed Dec 17 2003 - 20:06:18 CET