Posted by Tom Moreau on 02/18/06 21:14

Convert works, too. Cast is ANSI, while convert is T-SQL only.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com

"Dranai" <dranai@gmail.com> wrote in message
news:1140289709.094990.39720@o13g2000cwo.googlegroups.com...
Great, that is what I was looking for. I am very unfamiliar with the
SQL language, so I had no idea how to typecast. I did some web
browsing for how to do it, and honestly I got too many different
answers, so I wasn't sure which one to use. I was attempting to use
CONVERT(int, col1) first.

Thank you again for the help.

Chris

[Back to original message]