Drop 2 digits only from a 6 digit in colomn in a table
Posted on 2009-04-02
In a table I need to delete the first 2 digits of only certain data in a colomn.
12 - Do not change
145 - Do not change
664841 - Needs to be changed to 4841
485691 - Needs to be changed to 5691
157289 - Needs to be changed to 7289
By the way I don't know what I'm doing here so I've backed up the Database...