如何做到包含QQ，电话等显示到前面
------解决思路----------------------
DECLARE @i INT
DECLARE @j int
DECLARE @n INT
DECLARE @qq VARCHAR(100)
DECLARE @sr1 VARCHAR(100)
DECLARE @tel VARCHAR(100)
SET @qq=''
SET @tel=''
SET @i=0
SELECT @n=len(sr1) FROM ts_2
WHILE @i<@n
BEGIN
SET @i=@i+1
IF (SELECT substring(sr1,@i,1) FROM ts_2)='Q' OR (SELECT isnumeric(substring(sr1,@i,1)) FROM ts_2)=1
SELECT @qq=@qq + substring(sr1,@i,1) FROM ts_2
IF (SELECT substring(sr1,@i,1) FROM ts_2)=',' BREAK
END
SELECT @sr1=substring(sr1,@i+1,@n) FROM ts_2
SET @j=0
WHILE @j<@n
BEGIN
SET @j=@j+1
IF (SELECT substring(@sr1,@j,1) FROM ts_2)='手'
OR (SELECT isnumeric(substring(@sr1,@j,1)) FROM ts_2)=1
OR (SELECT substring(@sr1,@j,1) FROM ts_2)='机'
SELECT @tel=@tel + substring(@sr1,@j,1) FROM ts_2
IF (SELECT substring(@sr1,@j,1) FROM ts_2)=',' BREAK
END
PRINT @qq +' _ ' + @tel
------解决思路----------------------
select * into #t1 from tb1 where note like '%qq%' or note like '%手机%'
再处理#T1