You must Sign In to post a response.
  • Category: SQL Server

    Sql Function Convert mpney format to word format


    Are you looking for the method to convert number to word format using SQL? Read this thread to know the sql query to convert number to word.



    Hi, Using sql function how to convert number format to word format.
    For Example. : 123456.86
    My Ans is : One lakes Twenty three thousand fore hundred fifty six Rupees . Eight Six Pisa
  • #745961
    There is no such function exist in SQL which will convert it to Words You can try creating your own.

    You can create your own by reading this



    novicksoftware.com/udfofweek/Vol2/T-SQL-UDF-Vol-2-Num-9-udf_Num_ToWords.htm

    Thanks & Regards
    Anil Kumar Pandey
    Microsoft MVP, DNS MVM

  • #745964
    Hi,
    You can either do this conversion in SQL or from your front end. I would suggest you to do this conversion from your front end using JavaScript as the library for the number to word format is available.
    If you are still interested in SQL function then please refer: sqlservercentral.com/Forums/Topic794134-149-1.aspx


    Regards,
    Asheej T K


  • Sign In to post your comments