求一SQL语句(ASP+ACCESS),在线等!!!!!!!!!!!!!!!!!!!!!
说明:
ACCESS表BeautySpot的记录中,字段Provinces有如下内容(内容为 省份编号)
1
2
2
1,2
1,2,3
10,1,32
===============================
问题:
===============================
现有省份编号=1,如何在ASP中用一条SQL查询出表BeautySpot字段Provinces中含有该编号的记录
[解决办法]
select * from tt where instr( ', ' & Provinces & ', ', ',1, ')> 0
select * from tt where ', ' & Provinces & ', ' like '%,1,% '
select * from tt where ', ' & Provinces & ', ' like '*,1,* '
