Re: varchar2 and number

Try with function like this ...

create or replace function price (dolars varchar2,cents varchar2) return number is
begin
  return to_number(dolars||','||cents);
end;

or simply in pl/sql block

price = to_number(dolars||','||cents);

Jacek Received on Wed Aug 09 2000 - 00:00:00 CDT