Revised Query Like problems not filtering.

[seanybravo]

Could someone please tell me why this query is returning all of my records?

SELECT tblData.*, tblTitle.*, tblCustomCategory.* FROM (((((tblData LEFT JOIN (SELECT * FROM tblTitle IN 'E:\Websites\ebusinessdirectories\Database\Admin.mdb') AS tblTitle ON tblData.fldContactTitle = tblTitle.fldTitleID) LEFT JOIN tblCustomCategory ON tblData.fldCategory1 = tblCustomCategory.fldID) LEFT JOIN tblCustomCategory AS tblCustomCategory1 ON tblData.fldCategory2 = tblCustomCategory1.fldID) LEFT JOIN tblCustomCategory AS tblCustomCategory2 ON tblData.fldCategory3 = tblCustomCategory2.fldID) LEFT JOIN tblCustomCategory AS tblCustomCategory3 ON tblData.fldCategory4 = tblCustomCategory3.fldID) WHERE (tblCustomCategory.fldDefinition LIKE '%%' OR tblCustomCategory1.fldDefinition LIKE '%A_Sean[[]0[]]%' OR tblCustomCategory2.fldDefinition LIKE '%A_Sean[[]0[]]%' OR tblCustomCategory3.fldDefinition LIKE '%A_Sean[[]0[]]%') ORDER BY fldCompanyName

 

[PHV]

The following doesn't filter much !
tblCustomCategory.fldDefinition LIKE '%%'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[seanybravo]

Thanks for you help. I had an error in one of my functions generating the SQL.