ÇóSQLÒ»ÌõÓï¾äµÄ½â¾ö·½·¨

±ÈÈç ÎÒÓÐÒ»¸ö±í bumen

ÀïÃæ ÓÐÒ»¸öÁР quanxian
id  name  quanxian

1    a    001;002;003;
2    b    002;003;
3    c    003;004;
4    d    001;002;003;

ÎÒµÄÒâ˼ÊÇ°ÑquanxianÁÐÖк¬ÓÐ002µÄÊý¾ÝÈ¡³öÀ´£»ÏÔʾÔÚgridviewÉÏ£¿
Çë´óÏÀÃÇ°ï棡 

---

select * from tumen where quanxian like '%002%'

---

select * from tumen where quanxian like '%002%'
select * from tumen where charindex('002',quanxian) > 0

---

SQL code:

if object_id('ta') is not null drop table ta
go
create table ta(id int, name varchar(1), quanxian varchar(20))
insert into ta select
1, 'a', '001;002;003;' union all select
2, 'b', '002;003;' union all select
3, 'c', '003;004;' union all select
4, 'd', '001;002;003;'

select * from ta
where charindex(';002;',';'+quanxian)>0

id name quanxian
----------- ---- --------------------
1 a 001;002;003;
2 b 002;003;
4 d 001;002;003;

(3 ÐÐÊÜÓ°Ïì)

---

SQL code:
select * from tumen where charindex(','+'002'+',',','+quanxian+',') >