需要从 SQL 中的字符串中删除前 11 个字符

need to trim first 11 characters off a string in SQL

提问by njj56

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.

无论如何要修剪 varchar 中的前 x 个字符？我无法使用 left 或 right 函数以及其他修剪方法来做到这一点。将在标准 MS-SQL 上执行此操作。谢谢你。

回答by Martin Smith

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

(obligatory link)

（强制链接）

回答by dasblinkenlight

There are several ways of doing it. One of the simpler ones would be to use RIGHTand LENcombination:

有几种方法可以做到。更简单的方法之一是使用RIGHT和LEN组合：

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