34,594
社区成员
发帖
与我相关
我的任务
分享
select stuff(col,1,charindex('.',col)-1),'') as col from tb
declare @str varchar(200)
set @str = 'dkjksajlf.doc'
select substring(@str,charindex('.',@str),len(@str))
select stuff(col,1,charindex('.',col)-1)) as col from tablename
select right(col,len(col)-charindex('.',col)+1)
from tb
select col from tb where right(col,4) = '.doc'
--这样?
declare @s varchar(200)
set @s = 'dkjksajlf.doc'
select substring(@s,charindex('.',@s),len(@s))
substring(col,charindex('.',col),len(col)- charindex('.',col)+1)
update tab set
col = left(col,charindex('.doc',col)+3)
select right(aa,4) as aa from tablename