Criteria To Select Only Letters

[JJman]

I'm working in an Access Project to put criteria on an expression field to only show records where the left two characters are letters, not numbers. I've tried unsuccesfully using wildcards specific to each. Any help is appreciated!

 

[onpnt]

off the top of my head

SELECT *
FROM tableName
WHERE NOT isNumeric(Right([field],2));

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page faq333-3811

 

[onpnt]

nope...it would return one number and a char

sorry!

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page faq333-3811

 

[Golom]

Something like
[blue][tt]
fld LIKE [A-Z][A-Z]*
[/tt][/blue]

 

[onpnt]

learn something everyday. I didn't know you could use a regex pattern in the query. nice!

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page faq333-3811

 

[JJman]

Like "[a-z][a-z]*" worked great. Thanks to both of you!