Home Forums SQL Server 2005 SQL Server 2005 General Discussion convert number into words RE: convert number into words

  • July 4, 2012 at 6:37 am

    #1508760

    I would suggest creating and using CLR function. The base for it you can find here:

    http://www.c-sharpcorner.com/uploadfile/b942f9/converting-numbers-to-words-in-C-Sharp/

    You can enhance it to support any numbering style. Also, it's possible to reuse it in UI or/and server side code.

    I cannot say that you shouldn't save words into database, but I would do it if database designed for reporting purposes only.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]