Because of ODBC connection try:
SELECT 10.00 (FORMAT '$zzz9.99') (char(8))
Fred Keiser
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2004 Indexes