SELECT problems..WHERE x not in list not working??

From: <chilecayenne_at_yahoo.com>
Date: 30 May 2006 14:15:26 -0700
Message-ID: <1149023726.277681.100640@g10g2000cwb.googlegroups.com>

Hi all,

Maybe I'm just brain farting...but, I cannot for the life of me figure out why a simple query isn't working.

select a.projectname, NVL(d.catalognumber,'NULL') catalognumber, d.title course_title, e.title template_title from project a, projecttrainingneed b, candidatecourse c, course d, categorytemplate e
where a.projectid = b.projectid

and b.projecttrainingneedid = c.projecttrainingneedid
and c.courseid = d.courseid
and a.categorytemplateid = e.categorytemplateid

and upper(a.projectname) not in
('%LAKEHURST%','%OCEANA%','%PENSACOLA%') order by a.projectname, d.title;

But, on my results...I still get rows with Oceana, Lakehurst and Pensacola in them. Any clues as to why the NOT IN statement list with wildcards isn't working?

tia,

chilecayenne Received on Tue May 30 2006 - 16:15:26 CDT