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

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

Nuget pack csproj using nuspec -