Re: Query for Return character?

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0307160405.7bd3daf3_at_posting.google.com>...
> danieloconnor_at_dbt.net (Dan) wrote in message news:<f03dc8e4.0307151939.6ba27bf2_at_posting.google.com>...
> > I currently have return characters in my address text columns in my
> > Oracle db. This is not good for us. Can anyone tell me how to query
> > for these? I am trying to use a replace statement to replace with a
> > space but having no luck using chr(13).
> >
> > Thanks,
> > -Dan
>
>
> Try CHR(10) also.
>
> Regards
> /Rauf Sarwar

Yes, thank you both. I had previously tried using chr(13) but I guess windows inserts a chr(13) and a chr(10). Once I replaced both everything looked good.

Again thanks,
-Dan Received on Thu Jul 17 2003 - 02:28:48 CEST