Take a look at the CAST function.....
Cornelius Meade III EDS - Consulting Services/BI/CRM
Attachments
Library
Quick Reference
Archives
Sample Index
2006 Indexes