>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
Refrain from selecting variable-sized fields. Use padr() instead of alltrim().
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)