CAST () SQL's CAST () function is similar to CONVERT (); it lacks the date formatting capabilities CONVERT () has, but otherwise works in a similar fashion.

The last column shows the result of a Visual Basic CLR function ToDecimal, included in the code download, to convert from text to decimal as an alternative to the CAST function. The advantage is that ...