Thank this author by sharing:
By Don Frazier,
Function to format phone numbers entered as text.
format the number in indian currency format
My number formatting function doesn't work as expected
Number Format in SQL SERVER and SSRS
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.