>>This field is part of an SQL that will be saved via SDF to a text file. The problem I'm having is that it is always 16 in length, regardless of what I do to it in the SQL. It must be 12 in length and 2 decimal places. Any help greatly appreciated. Thanks!
>>
>>

>>SUM(VAL(STR(new.ee_bal,12,2))) AS ee_bal,;
>>

>
>I really wanted to write "Pull the trigger" <g>
>
>
>Anyway, for VFP 9 use CAST, for VFP8 - use
>sum(myVal + 000000000000.00)

Needed 000000000.00, but it didn't work regardless. Still get 16 in length in the result.