转自:http://blog.csdn.net/yangbindxj/article/details/13146047
select * from KKKK
where cast(Value as varchar(40)) like '%红豆%'
where cast(Value as varchar) like '%红豆%'
两种方式都可以。
注意:cast为关键字,Value为需要查询的列。
转自:http://blog.csdn.net/yangbindxj/article/details/13146047
select * from KKKK
where cast(Value as varchar(40)) like '%红豆%'
where cast(Value as varchar) like '%红豆%'
两种方式都可以。
注意:cast为关键字,Value为需要查询的列。