Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest.

This way I can take impossible-to-sort varchars, and sort them by the converted field instead, making the recordset prettier.<BR><BR>Right now SCNumber might look like the above, '99' implying ...

Arthur Fuller responds to a reader who sent him a question recently asking how to display currency amounts in currency format. Check out the solution he offers for the reader's problem.