Concatenate the $ symbol...
SELECT '$'||trim(10.00)
Best Regards
Chris Coffing AFKS O&M Lead Teradata DBA Certified Teradata Master
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2004 Indexes