var a =[1,2,3,4]
或者 var b= [1,2,3,4,5,6,7]
要截取a中最后一个，和]中间的数字···
即a截取后的值是4···b截取后的值是7
sql??截取
------解决方案--------------------------------------------------------
DECLARE @i VARCHAR(20)
SET @i = '[1,2,3,4]'
SELECT SUBSTRING(@i,LEN(@i)-1,1)
------解决方案--------------------------------------------------------
DECLARE @s VARCHAR(20)
SET @s = '[1,2,3,2344]'
select replace(right(@s,patindex('%,%',reverse(@s))-1),']','')