SELECT * FROM product WHERE (( (description LIKE '%%' OR MFG Like '%%'))AND (PRODUCT_ID LIKE '%%') AND (PartNo LIKE '%lex-58D1000%') AND ((CATEGORY LIKE '%%') OR (CATEGORY = '')) AND ((SUB_CAT LIKE '%%') OR (SUB_CAT IS NULL) OR (SUB_CAT = '')) AND ((SUB_CAT2 LIKE '%%') OR (SUB_CAT2 = '') OR (SUB_CAT2 IS NULL) ) AND ((MFG LIKE '%%') OR (MFG = ''))) ORDER BY PartNo, product_ID

Found