Re: varchar2 and number

Hi,

First of all, have you try with a point rather than a comma ? And if it still doesn't work, may be it's possible to do :  Price = Dollar + cents/100
It works in SQL but I don't know with Form ... may be you also need the to_number() function ?

Bye.

Sandy a écrit :
>
> hi,
>
> I have a form with two fields one for a number and for the
> decimal. I tried the character '||'to put them together in
> the same variable then it would be a number(15,2) but of
> course it doesn't work because i do like this :
>
> Price number(15,2);
> Dollar varchar2(15);
> cents varchar2(2);
>
> Price=Dollar ||','||cents;
>
> ...
> Is there a functin or anything to do it ?
>
> thanks a lot
>
> Sandy
 

-- 
 Pierre CHARPENAY