Begins With search (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


chadb -> Begins With search (3/5/2008 15:40:05)

I want to do a search with multiple choices, example by PO = PO or CO = CO or Customer Begins like. The problem is that the customer begins is making the search results return all records? Hope that makes sense, here is the query string:

fp_sQry="SELECT * FROM Shipments WHERE (Customer LIKE '::Customer::' OR PO = '::PO::' OR CO = '::CO::')"




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625