The below query I was hoping would ONLY show me criteria if for starters part.character03 = 'Package' along with other criteria, yet it still shows me values within Character03 that are OTHER THAN "Package"
I tried part.character03 = 'PACKAGE' and I get an errors saying: The data types text and varchar are incompatible in the equal to operator.
Any help is appreciated
SELECT part.partnum, part.character03, shipdtl.packnum
FROM shipdtl INNER JOIN
part ON shipdtl.partnum = part.partnum
WHERE (part.character03 LIKE 'PACKAGE') AND (shipdtl.packnum = 221) OR
(shipdtl.packnum = 222) OR
(shipdtl.packnum = 224)