select * from tablename where columnname like '%查询的字符串%' 如果是整型,可以这样: select * from tablename where CONVERT(VARCHAR(50),columnname) like '%查询的字符串%'满意请采纳