Query for Return character?

From: Dan <danieloconnor_at_dbt.net>
Date: 15 Jul 2003 20:39:07 -0700
Message-ID: <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 Received on Wed Jul 16 2003 - 05:39:07 CEST

Original text of this message