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 24, 2011 at 6:22 am

    #1357527

    andrew.sugden (7/24/2011)

    Fair enuff. In the scenario I was using it I wanted to get rid of 3 letters that had been added to a file number e.g

    CaseCode: 1017856AVN.

    In database wanted to link it to the file number & file type were in separate columns i.e.

    Case number: 1017856 Case type: AVN

    So to get CaseCode in 1st DB to match Case number in 2nd DB Kingston's REPLACE worked fine.

    All we said is that it can delete the wrong data with replace. Left is clear as day. Whack the last 3 characters and most importantly, it cannot fail.