Syntax for CAST:
CAST ( expression AS data_type [ (length ) ])

Syntax for CONVERT:
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
http://msdn2.microsoft.com/en-us/library/ms187928.aspx 
Advertisements