Search results

Hello, I need to write a query that shows all records if any 'L' field starts with D. I have written this, but it's only pulling records if L1 starts with D. SELECT Item, Description, L1, L2, L3, L4, L5, L6, L7, L8, L9, L10, L11, L12 FROM Table5 WHERE ((L1 LIKE 'D*') OR (L2 LIKE 'D*') OR (L3...