declare @str as varchar(100) set @str = '/a/b/c/d/' set @str = substring(@str,1,7) print @strset @str = '/a/b/c/d/' set @str = stuff(@str,8,2,'') print @strset @str = '/a/b/c/d/' set @str = stuff(@str,8,2,'') print @str/* /a/b/c/ /a/b/c/ /a/b/c/ */
declare @str as varchar(100) set @str = '/a/b/c/d/' set @str = reverse(LEFT(@str,(len(@str)-1))) set @str = reverse(STUFF(@str,0,charindex('/',reverse(LEFT(@str,(len(@str)-1)))),''))
set @str='/a/b/c/d/'
--从开始截取
select substring(@str,1,7)
--从后边截取
select reverse(stuff(stuff(reverse(@str),1,1,''),1,charindex('/',stuff(reverse(@str),1,1,''))-1,''))
set @str = '/a/b/c/d/'
set @str = substring(@str,1,7)
print @strset @str = '/a/b/c/d/'
set @str = stuff(@str,8,2,'')
print @strset @str = '/a/b/c/d/'
set @str = stuff(@str,8,2,'')
print @str/*
/a/b/c/
/a/b/c/
/a/b/c/
*/
set @str = '/a/b/c/d/'
set @str = reverse(LEFT(@str,(len(@str)-1)))
set @str = reverse(STUFF(@str,0,charindex('/',reverse(LEFT(@str,(len(@str)-1)))),''))