Re: return characters ?

I do not know if this will help you or not. But you will have to make you iwn function to do this also you have to intruduce paddin inthe result.
so you will have 3 digits to show the ascii code for all the charachters. Tom

create fucntion to_ascii(val in varchar2 default null) return varchar2
is
ret_val varchar2(2000) default null;
begin
for i in 1..length(val) loop
ret_val:=ret_val||ascii(substr(val,i,1)); end loop;
return ret_val;

select to_ascii('name') from dual;

archaos <archaos_at_ifrance.com> wrote in message news:8890ih$la7$1_at_jaydee.iway.fr...
> I have "return" chracters in my database .. and I would like the result of
> the query with the
> "return" chracters in ascii . How can I do that ?
>
>
Received on Tue Feb 15 2000 - 00:00:00 CET