Conversion from smallint to char

mayapaskaleva · #1 (**permalink**) 11-08-07, 11:22

Could anybody say me how to convert smallint value to char ?
For example if:
cost.amount - smallint
print.laber - char

how I can update print.label with cost.amount. I couldn't find routine for this!
Help!

Maya

Tyveleyn · #2 (**permalink**) 11-09-07, 17:47

Hi, if you just want to store the value of cost.amount into print.label do:

Code:

UPDATE print SET label = 
    (SELECT amount FROM cost WHERE cost.key = print.key)
WHERE key = ...

If you want to perform a calculation with both the print.label and cost.amount and you work with IDS 9.x or higher do an explicit cast, like:

Code:

SELECT cost.amount + print.label::smallint 
FROM print, cost
WHERE ...

Regards

Internet Services

Web Development

Digital Marketing

Consumer Tech