Home Forums SQL Server 2008 SQL Server 2008 - General How to remove comma and convert in to INT RE: How to remove comma and convert in to INT

  • June 17, 2013 at 4:57 am

    #1624535

    There are 2 ways to do this

    SELECTCONVERT(NUMERIC(17,2),REPLACE(REPLACE(data,',',''),'$',''))

    FROMdataconvert

    SELECTCONVERT(MONEY,REPLACE(data,',',''))

    FROMdataconvert

    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/