Re: Query for Return character?
From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 16 Jul 2003 05:05:06 -0700
Message-ID: <92eeeff0.0307160405.7bd3daf3_at_posting.google.com>
Date: 16 Jul 2003 05:05:06 -0700
Message-ID: <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
Received on Wed Jul 16 2003 - 14:05:06 CEST