求查询语句。

Question

本帖最后由 todown 于 2010-10-07 10:53:58 编辑

Answer 1

Select * 
From content 
Where 品牌 = '" & BrandTemp & "' and replace(型号,'...','...') = '" & temp2 & "' 

Answer 2

select * from  dbo.Vendor select * from  dbo.Vendor 
where replace(VendorName,'oo','mm')='Gmmgle'VendorID    VendorName
----------- --------------------
1           Huawei
2           IBM
3           Google(3 row(s) affected)VendorID    VendorName
----------- --------------------
3           Google(1 row(s) affected)