如何去掉某个字符前的字符串

Question

如： 列a
     1/a
     222/b
     22/cfd
如何获取/后的数据
即   列 a
        a
        b
        cfd

Answer 1

select right(列a,len(列a)-charindex('/',列a)) 
from tb

Answer 2

left reverse
right
substring
stuff
-- ...

Answer 3

select replace(列a,left(列a,charindex('/',列a)),'')
from tb

Answer 4

select SUBSTRING(a,charindex('/',a)+1,len(a)) from [tablename]