Script Wildcard not working as expected

[#1]

I am trying to eliminate unwanted junk data from my list box views so I added the command to the script.  It is not working so I'm asking for some feedback on what is the correct way to do this.

Here is the junk I'm trying to eliminate:

And here are the commands:

FROM "DW_LMKPSFT"."PSD_PS_XR_COMPANY"
WHERE BO_NAME <> 'ABCDE Guest' or BO_NAME <>'*OUT*' or BO_NAME <> '*DUP*';

Also:

SQL SELECT "CASE_CONTACT",
NAME as CONTACT_NAME
FROM "DW_LMKPSFT"."PS_XR_CONT_NAME_VW"
WHERE NAME <>'*??**' or NAME <>'*zzz**'
;

Any help is greatly appreciated!

[sunny_talwar]

Thanks for sharing this John!!