njj56 njj56 - 2 months ago 6
SQL Question

need to trim first 11 characters off a string in SQL

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
SELECT STUFF(SomeString,1,11,'')

(obligatory link)