Will this work like I intend it to? I want all wh.partnumber that beginning with 10839 or 10879, and are also in 'K110' status and completed date is null. I'm unsure on my use of brackets around the or statement after the "and".
WHERE ws.WO_STATUS = 'K110'
AND ws.COMPLETED_DATE IS NULL
and (wh.PARTNUMBER like '10839%' or wh.PARTNUMBER like '10879%')