According to Larry the FoxPro dtaBase doesn't support convert but when using Sybase I would say
select convert (decimal(8,4), sum(amount)) as mynumber, blah, blah
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California