NOT not working to exclude text

[Pedagogic368]

Hello - I have one table from which I need to exclude pharmacy's based on their store numbers. I have been trying to do this using "NOT" - However it returns NOTHING (still after several hours of trying)???

SELECT Sheet1.[ID], Sheet1.[PHARMACY], Sheet1.[PRODUCTNAME], Sheet1.[NDCNUM], Sheet1.[assign], Sheet1.[Carrier], Sheet1.[Last], Sheet1.[First], Sheet1.[City], Sheet1.[State]
FROM Sheet1
WHERE (((Sheet1.[PHARMACY]) Not Like "*04505*"));

But if I use "Like", all the pharmacy's with the number 04505 are listed out correctly

SELECT Sheet1.[ID], Sheet1.[PHARMACY], Sheet1.[PRODUCTNAME], Sheet1.[NDCNUM], Sheet1.[assign], Sheet1.[Carrier], Sheet1.[Last], Sheet1.[First], Sheet1.[City], Sheet1.[State]
FROM Sheet1
WHERE (((Sheet1.[PHARMACY]) Like "*04505*"));

Can someone please advise me what I should be writing to exclude pharmacy's based on store numbers. Thanks in advance.

[JoeM]

It seems to be saying that every store in your "Sheet1" table has "04505" as part of the pharmacy number.
Can you confirm that is not the case?
Can you provide some examples of pharmacy codes that do NOT contain this number?

[Pedagogic368]

thanks for the quick reply-

Here are some examples of Pharmacy stores that should be EXCLUDED-

Walgreens Drug Store 4542*
Walgreens Drug Store 04505*

Here are some examples of Pharmacy stores that should be INCLUDED -

Walgreens Drug Store 06270*
Walgreens Drug Store 07179*

This is how they are listed in one of the columns on the original sheet.

Thanks again for your reply

[JoeM]

Do they really actually have an asterisk in the Pharmacy ID value, or are you just cutting it off for purposes of this example?