请问怎么实现把一个字段内容的后边的多余的内容去掉

Question

用SQL语句实现比如:source       originalSource
     网易/汽车       网易就是说把网易后边的斜杠和内容都去掉,导入到originalSource字段中只能网名,怎么实现?

Answer 1

update tb
set originalSource=substring(source,1,charindex('/',source)-1)

Answer 2

select stuff(source,charindex('/',source),len(source) - charindex('/',source) + 1)
from tb

Answer 3

select stuff(source,charindex('/',source),len(source) - charindex('/',source) + 1,'')
from tb

Answer 4

select originalSource=parsename(replace(source,'/','.'),2)  from tb

Answer 5

update tb
set originalSource=left(source,charindex('/',source)-1)

Answer 6

SELECT LEFT(FNAME,CHARINDEX('/',FNAME)) FROM T_ACCOUNT