ASP.NET, SQL Server, WPF, C#, VB.NET

Good afternoon, 
 
I'm trying to exclude results returned by a query.  I have a field  which 
 
has the following values: Released, On hold, Maturity A, Maturity B and 
 
Maturity C. 
 
I wish to exclude all the records where the value = Maturity *.  As such I 
 
added 'Not Like "Maturity*"' as the criteria for this field.  To my amazment, 
 
instead of eliminating these records the query returns only those values. 
 
For fun I removed the "Not" in the criteria and I get the exact same records 
 
returned??? 
 
How can I exclude the "Maturity*" records?  Why isn't my Not Like criteria 
 
acceptable? 
 
Thank you, 
 
Daniel

On Thu, 6 Jul 2006 12:43:02 -0700, Daniel 
 
<Daniel@discussions.microsoft.com> wrote: 
 
It should be. There's evidently something else going on! 
 
Could you open your Query in SQL view and post the entire SQL string 
 
here? 
 
John W. Vinson[MVP]

On Thu, 06 Jul 2006 20:30:34 GMT, "tiger0268 via AccessMonster.com" 
 
<u18752@uwe> wrote: 
 
minor correction: The "Not" operator and the "is not equal" operator 
 
<> are different. The last of these should be 
 
<> "Maturity A" AND <> "Maturity B" 
 
or, if you prefer, 
 
NOT IN("Maturity A", "Maturity B") 
 
John W. Vinson[MVP]

try: 
 
Not Like "Maturity*" 
 
If that don't work try 
 
Not Like "Maturity" & "*" 
 
If that don't work, you can always just eliminate each one individually: 
 
Not "Maturity A" And Not "Maturity B" 
 
Daniel wrote: 
 
-- 
 
Message posted via AccessMonster.com 
 
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200607/1