I have column named Column1 looks like this:
ABCABC321
ABCABC213
ABC478
ABC474
Here is a query to show all extra characters of 'ABC'
select * from TABLE where Column like 'ABCABC%';
This is the output:
ABCABC321
ABCABC213
How can I delete the extra 'ABC' for all records from the query used above?
This is the desired output:
ABC321
ABC213
ABC478
ABC474