A couple techniques:
SELECT RIGHT(abc_col1,len(abc_col1)-2)
FROM tableA
SELECT REPLACE(abc_col1,'SH','')
FROM tableA
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001