i m using SQL server 2005
Don't worry, you can use CONVERT and CAST in SQL Server 2005.
How to post forum questions.Need an answer? No, you need a question.What’s the deal with Excel & SSIS?
My blog at SQLKover
MCSE Business Intelligence - Microsoft Data Platform MVP