Need to trim first 11 characters from a string in SQL

Question

Is there a way to trim the first number of characters in varchar? I cannot do this using left or right functions, as well as other cropping methods. Will do this on standard MS-SQL. Thanks.

Answer 1

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

( required link )

Answer 2

There are several ways to do this. One simple would be to use RIGHT and LEN :

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