njj56 njj56 - 1 year ago 104
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 Source
SELECT STUFF(SomeString,1,11,'')

(obligatory link)

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download