Skip to main content

Posts

Showing posts from February, 2013

Sql Query to add comma in price using SQL Server

Introduction: In my previous article I have explained about How to get selected items text   using Javascript . In this article I am going to explain about how to format numbers in indian(1,23,45,67,890) and US(1,234,567,890) style in SQL . Explanation: To format the numbers in indian style I have wrote two sql functions. First function will add the comma(,) after 3 digits from right and the second function will add comma after two two digits from the 3 rd digit onward from the right.