Home Forums SQL Server 2008 T-SQL (SS2K8) Convert character data to decimal RE: Convert character data to decimal

  • August 19, 2013 at 10:39 am

    #1642770

    Sean Lange (8/19/2013)

    No need for a case expression here at all. Just convert the value, it will give you the negative values just fine.

    CONVERT(decimal (18,2),REPLACE(LTRIM(REPLACE(TestData,'0',' ')),' ','0'))

    Duh!!! I missed that. :w00t:


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]