To do it use cast(CAST(date AS DATE FORMAT 'MMDDYYYY') as varchar(8))
Rachana
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2003 Indexes