Sherry,

SQL determines the format by the first value it sees. You can use PADR(cMyField, x) for character fields, nMyField + 000000.00 to format a numeric field, or nMyField + $0 for currency fields.

>Thanks for your help. One more thing how do I format a field in a sql statement. I am using a sum function in the sql, some of the number display "****".
>sherry