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

  • July 22, 2011 at 10:10 am

    #1357171

    Kingston Dhasian (1/22/2010)

    Try this if this works..

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

    This won't work if the last 3 characters are used in the same sequence elsewhere in the string. I'd really go with the left(len)) option here.