need to trim first 11 characters off a string in SQL

SELECT STUFF(SomeString,1,11,'')

(obligatory link)

There are several ways of doing it. One of the simpler ones would be to use RIGHT and LEN combination:

select RIGHT(a.col, LEN(a.col)-11) from MyTable a