Query for Return character?

[Dan]

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

[Dan]

Re: Query for Return character?

rs_arwar@hotmai l.com (Rauf Sarwar) wrote in message news:<92eeeff0. 0307160405.7bd3 daf3@posting.go ogle.com>...

danieloconnor@d bt.net (Dan) wrote in message news:<f03dc8e4. 0307151939.6ba2 7bf2@posting.go ogle.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