select * from info where region=N'北京' and city like N'海淀%'-- N'' 表示unicode字符串--或者这样也行 select * from info where cast(region as varchar(8000))='北京' and cast(city as varchar(8000) like '海淀%'
select * from info where cast(region as varchar(8000))='北京' and cast(city as varchar(8000)) like '海淀%' 少写了个“)”
select * from info where cast(region as varchar(8000))='北京' and cast(city as varchar(8000) like '海淀%'
少写了个“)”