>>Jay - are you trying to do a select or create a table - I'm assuming you are creating a table..?
>
>Select.
Is your SQL Server case-sensitive? Try with CAST in upper case then or show the whole select statement, it would be easier to see the error.
If it's not broken, fix it until it is.
My Blog