Re: Query for Return character?

"Dan" <danieloconnor_at_dbt.net> schrieb im Newsbeitrag 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

Hi Dan,

if you don't know the chr(n), just use ' '. That is a single space. BTW: it's represented by CHR(32).

hth,
Guido Received on Wed Jul 16 2003 - 12:41:44 CEST