Question:
How do I remove the first two characters of every row in this column?Answer:
If you are using MSSQL You can useSTUFF
like this to see how it works:SELECT STUFF('0123456789',1,2,'')
And then with an update
UPDATE YOUR_TABLE SET YOUR_COLUMN = STUFF('YOUR_COLUMN',1,2,'')
if you were using mysql there is an similar function
INSERT()
There are a few different ways to do this, you can play with
SUBSTRING
or even regular expressions depending on your database.If you have better answer, please add a comment about this, thank you!