There is a set of data that I pulled from a server and in one of the fields, every value has the first 3 letters "DFT" with 2 or 3 letters following that. I want to use an SQL statement along the lines of:
SET column1=[string after first 3 letters]
WHERE [first 3 letters of string]='DFT';
UPDATE table_name SET column1 = MID(column1, 4, LEN(column1) - 3) WHERE MID(column1, 1, 3) = 'DFT'