>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,;
>
How about
SELECT ....,SUM(new.ee_bal) AS ee_bal.......
INTO CURSOR myCursor READWRITE
ALTER TABLE myCursor ALTER ee_bal n(12,2)