SQL Server 2000 CAST and CONVERT

Anyone who's written SQL statements has undoubtedly had to CONVERT values from one data-type to another. I do this quite regularly, specifically with converting a varchar value to a specific date format, or converting a date from one format to another.

 

By now I've got most of the different options memorized, but this MSDN reference always was a life saver in the middle of the night when I couldn't quite remember what I was after.

 

http://msdn2.microsoft.com/en-us/library/aa226054(SQL.80).aspx

 

Enjoy!