SQL statement assistance

[dksj67]

I would like to create an Access query based on a text field with a result
set that would not include records where the text in that field starts with
the letter z or Z. How do I write an SQL WHERE statement that performs this
function?

Thanks,

Dan Kreiling

 

[fredg]

I would like to create an Access query based on a text field with a result
set that would not include records where the text in that field starts with
the letter z or Z. How do I write an SQL WHERE statement that performs this
function?

Thanks,

Dan Kreiling

Where YourTable.[Fieldname] Not Like "Z*"

or you could use:
Where Left(YourTable.[Fieldname],1) <> "Z"

Access is case insensitive, so "Z" and "z" are treated the same in
this instance.

 

[Marshall Barton]

I would like to create an Access query based on a text field with a result
set that would not include records where the text in that field starts with
the letter z or Z. How do I write an SQL WHERE statement that performs this
function?

SELECT *
FROM table
WHERE Left(textfield,1) <> "z"

 

[dksj67]

Very good. Thank you

SELECT *
FROM table
WHERE Left(textfield,1) <> "z"

 

[John Spencer]

WHERE SomeField LIKE "[!z]*" Or SomeField is Null

Alternative

WHERE SomeField NOT LIKE "z*" Or SomeField is Null


John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County