CAST vs CONVERT

Both these functions are used to convert values from one datatype to another But there are some differences between them 1 CAST is ANSI standard and CONVERT is specific to SQL Server 2 CAST can&#39;t be used for formating purposes. But CONVERT can be Read More......(<a href="http://sqlserver-qa.net/blogs/extblog/archive/2010/07/22/cast-vs-convert.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9366" width="1" height="1">