| Subject | Re: [firebird-support] Converting with parameters stored in variables? |
|---|---|
| Author | Virna Constantin |
| Post date | 2019-08-29T14:14:52Z |
select right('000000000'||(10.3+0.000),10) from rdb$database
Hello,
I get from a application the following
100
R10.3
Or
22.22
R10.3
Now I should take it into:
0000000100.000
And
0000000022.220
I think, I cannot simply (cast :input as :vartype) (vartype = ‘decimal(10.3)’
Also it will fortunately not work: cast(input as decimal(:v1,:v2) (v1 = 10 v2 = 3).
How can I realize it without dismantle the 10.3 and the 22.22?
Thank you.