By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,190 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

Query for Return character?

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Dan
rs******@hotmail.com (Rauf Sarwar) wrote in message news:<92**************************@posting.google. com>...
da***********@dbt.net (Dan) wrote in message news:<f0**************************@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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.