Here's my code:

select alltrim(str(int(number))) as number from table into table1

(number = 345.0000)
However, number comes in to table1 as a char 10 when I want it to be char 3. I thought the alltrim would fix that but it didn't.

Any suggestions?

Thanks,
Sunshine