Convert number in Indian currency format in SQL Server

Question

string format for indian rupee in sql like

nagaraju60 · Accepted Answer

Dear Moni         It is simple to convert a number into Western Currency Format but if to convert it into Indian Currency Format there is no direct Inbuilt Function available in MS SQL To convert it into Indian Format you need to write an SQL scriptPlease refer below articlehttpsqlserver20blogspotin201205convertnumberintoindiancurrencyhtml

dharmendr · Answer

Hi MoniCheck the test querySQLDECLARE InNumericValue NUMERIC382SET InNumericValue  111654823853DECLARE RetVal VARCHAR60        StrRight  VARCHAR5         StrFinal  VARCHAR60        StrLength INT                 SET RetVal  3939SET RetVal InNumericValue SET RetVal SUBSTRINGRetVal1CASE WHEN CHARINDEX3939 RetVal0 THEN LENRetValELSE CHARINDEX3939RetVal1 ENDSET StrLength  LENRetValIFStrLength gt 6BEGIN      SET StrFinal  RIGHTRetVal6               SET RetVal  SUBSTRINGRetVal5StrLength      SET StrLength  LENRetVal      IF LENRetVal gt 0 AND LENRetVal lt 3            BEGIN            SET StrFinal  RetVal  3939  StrFinal            END      WHILE LENRetVal gt 2            BEGIN            SET StrRightRIGHTRetVal2                           SET StrFinal  StrRight  3939  StrFinal            SET RetVal  SUBSTRINGRetVal1StrLength            SET

Convert number in Indian currency format in SQL Server

Company

Explore

Follow us

Contact Us