Query Issues 1

[Mighty]

I have the following query:

SELECT DISTINCT [Complaint Details].[Complaint Number], [Customer Master].NAME_23, [Complaint Details].[Complaint Date] FROM (([Complaint Details] INNER JOIN [Customer Master] ON [Complaint Details].Custid = [Customer Master].CUSTID_23) INNER JOIN [Actions] ON [Complaint Details].[Complaint Number] = Actions.[Complaint Number]) LEFT JOIN [Parts List Query] ON [Complaint Details].[Complaint Number] = [Parts List Query].[Complaint Number] WHERE (UCase([Complaint Details].Details) LIKE '*PROXIMAL*' OR UCase(Actions.Details) LIKE '*PROXIMAL*') ORDER BY [Complaint Details].[Complaint Number]

I am trying to run this query from an ASP page. However, it is returning no records. If I copy this text into a query on the actual database and run it, it returns 20 records - even though the queries are identical.

The Details fields in question in the query are both Memo fields. Can anyone explain why the database returns records when I run the query locally but it won't return any records when I run it from an ASP page?

Mighty

 

[Mighty]

Replaced the * with % and it worked fine??

Mighty

 

[PHV]

* is the wildcard for DAO and JetSQL
% is the wildcard for almost all the rest, included ADODB.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886