select substring(col,charindex(',',col),len(col)-charindex(',',col)) from tb
select substring(col,charindex(',',col),len(col)-charindex(',',col)) from tb
create table tt ( name varchar(20) ) insert into tt select '我,me' union all select '你,you' union all select '我们,we' select SUBSTRING(name,CHARINDEX(',',name,0)+1,LEN(name)-CHARINDEX(',',name,0)) from tt;
select parsename(replace(col,',','.'),1) from tb
select parsename(replace(col,',','.'),1) from tb
--有一种解决方法叫,脱了裤子放个屁,然后在穿上 DECLARE @a AS VARCHAR(20)='ffdad,we' SELECT REVERSE(SUBSTRING(REVERSE(@a),1,CHARINDEX(',',REVERSE(@a))-1))
select substring(name,charindex(',',name)+1,10) from tt或select substring(name,charindex(',',name)+1,LEN(name)) from tt
差了一个+1,呵呵
SET @TEST = N'你,you'
SELECT RIGHT(@TEST, LEN(@TEST)-CHARINDEX(',', @TEST))
select substring(col,charindex(',',col),len(col)-charindex(',',col)) from tb
create table tt
(
name varchar(20)
)
insert into tt
select '我,me' union all
select '你,you' union all
select '我们,we' select SUBSTRING(name,CHARINDEX(',',name,0)+1,LEN(name)-CHARINDEX(',',name,0)) from tt;
--有一种解决方法叫,脱了裤子放个屁,然后在穿上
DECLARE @a AS VARCHAR(20)='ffdad,we'
SELECT REVERSE(SUBSTRING(REVERSE(@a),1,CHARINDEX(',',REVERSE(@a))-1))
me
you
we