sql - How to convert dollar money to Indian currency without function -
i have convert money comma separated
select convert(varchar, cast(250233870.06 money), 1) result :
money 250,233,870.06 but want in indian rupee format
like desired output :
money 25,02,33,870.06
you can use format if have sql server 2012 or above this.
select format(cast(250233870.06 money),'n','en-in') output
25,02,33,870.06
Comments
Post a Comment