Home Forums SQL Server 2005 T-SQL (SS2K5) How to Delete Right 3 Characters from a string RE: How to Delete Right 3 Characters from a string

  • January 22, 2010 at 10:03 am

    #1107433

    Try this if this works..

    UPDATE Table SET Column = REPLACE( Column, RIGHT(Column, 3), '' )

    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/