Actually transform() is in the help for 2.6 so I tried it.

My code:
(number=123.25)
select transform(number,'XXX') as number it goes into table1 as char 3 but = to XXX!

Sunshine