Question:How do I remove the first two characters of every row in this column?
Answer:If you are using MSSQL You can use
STUFFlike this to see how it works:
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
There are a few different ways to do this, you can play with
SUBSTRINGor even regular expressions depending on your database.
If you have better answer, please add a comment about this, thank you!