sql整型字段模糊查询

select count(*) cnt from vhuiy where CAST(id as text) like'%12%'--id为int类型

更详细的链接：http://www.studyofnet.com/news/279.html