need to trim first 11 characters off a string in SQL

Question

Is there anyway to trim the first x amount of characters in a varchar? I am unable to do this using the left or right functions a well as other trimming methods. Will be doing this on standard MS-SQL. Thank you.

Answer 1

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

(obligatory link)

Answer 2

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