SELECT invoice_id
FROM <YOURTABLE>
WHERE LEFT(invoice_id, 6) NOT IN
(
SELECT DISTINCT LEFT(invoice_id, 6)
FROM <YOURTABLE>
WHERE (RIGHT(invoice_id, 4) = '0001')
)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day