declare @str varchar(100)
set @str = '60cdkkkkklmmmn'
print substring(@str,charindex('k',@str)+1,(len(@str)-charindex('m',reverse(@str))-charindex('k',@str)))
sql截取字符串
最新推荐文章于 2023-08-07 15:54:04 发布
declare @str varchar(100)
set @str = '60cdkkkkklmmmn'
print substring(@str,charindex('k',@str)+1,(len(@str)-charindex('m',reverse(@str))-charindex('k',@str)))