sql server資料批量模糊查詢

問題

資料為
ID 串碼
1 A0000000001
2 A0000000002
3 A0000000003
4 A0000000004
5 A0000000005
6 A0000000006
7 A0000000007
要求：
給出一個查詢範圍如
A0000000003,A0000000006

sql執行語句

 

代碼如下

複製代碼

create table t10(ID int,串碼 varchar(20)) insert into t10 select 1, 'A0000000001' union all select 2, 'A0000000002' union all select 3, 'A0000000003' union all select 4, 'A0000000004' union all select 5, 'A0000000005' union all select 6, 'A0000000006' union all select 7, 'A0000000007' -- 程式中輸入的串@x declare @x varchar(50) select @x='A0000000003,A0000000006' select * from t10 where 串碼 between left(@x,charindex(',',@x)-1) and substring(@x,charindex(',',@x)+1,20) ID          串碼 ----------- -------------------- 3           A0000000003 4           A0000000004 5           A0000000005 6           A0000000006