Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest. Home; News; Tips & How-To; ... The syntax for this function is FORMAT (value, format [, ...

Displaying money values in currency format in SQL ... For example, Access, VB, and .NET offer the Format() function, which handles this problem nicely.