>Hi. One of my sql result columns is only 1 character wide (numeric). I am thinking that it is because the first group value (for this field--a calculated one) is 0. How would I force the width of this field. Keep in mind that I am in Fox 7.
>
>Thanks, Randy
Something like that:
SELECT 000000000.00 AS Fld
will give you N(12,2) as result.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.