• This link should explain what needs to be done.

    http://www.sqlservercentral.com/Forums/Topic558696-338-1.aspx

    However, you may need an additional cast since your numerics are stored in a non-numeric datatype.

    Also, if you look at the solution, it is a lot of work to get what you want and depending upon how many rows this is being applied against, it could slow the query down. That is why it is recommended that formatting of this nature be done at the presentation layer instead of the backend.

    __________________________________________________________________________________________________________
    How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/