>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 ------------ ok thanks - I will add this to my notes... :)))
Robert Keith Independent Developer San Antonio, Texas E-mail address: rebelrob1@yahoo.com
