>>>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.
CREATE CURSOR ForExport (.......,SumColumn N(12,2),.....)
INSERT INTO ForExport;
SELECT ......,SUM(new.ee_bal),.....;
FROM .....
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.