22,209
社区成员
发帖
与我相关
我的任务
分享
select substring(@STR,charindex('<<',@STR)+2,charindex('>>',@STR)-charindex('<<',@STR)-2)
DECLARE @STR VARCHAR(500);
SET @STR = 'LYTES<<8888>>中';
SELECT COl=LEFT(col,CHARINDEX('>>',COl)-1) FROM (SELECT stuff(@str,1,CHARINDEX('<<',@str)+1,'') AS Col)t
/*
8888
*/
DECLARE @STR VARCHAR(500);
SET @STR = 'LYTES<<8888>>中';
SELECT substring(@STR,charindex('<<',@str)+2,charindex('>>',@str)-charindex('<<',@str)-2)
/*
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
8888
(1 行受影响)
*/