Excluding Alpha character in text field by filtering.

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

I have a query based on a table./

I have one numeric field that has alphanumber entries: A2000-000;
101010010,A2004, etc..

I what the filter to exclude all records that have an apph beginning - ie.
in eg. above exclude: A2000-000,A2004.

How do I do this?

Your assistance is greatly appreciated.
 
You could use

WHERE Left$(AlphanumericField, 1) NOT BETWEEN "A" AND "Z"

or

WHERE Val(AlphanumeriField) <> 0
 
Thanks a lot for updater. Tried the first opiton without success. Something
wrong with string.
 
I have a query based on a table./

I have one numeric field that has alphanumber entries: A2000-000;
101010010,A2004, etc..

I what the filter to exclude all records that have an apph beginning - ie.
in eg. above exclude: A2000-000,A2004.
Click to expand...

Use a criteirion of

LIKE "[!A-Z]*"

That is - the first character is NOT (! means NOT in this context) in the
range A to Z, the rest of the string can be anything (*).


John W. Vinson [MVP]
 
Hi John:

Thanks a bunch, tried the LIKE "[!A-Z]*" string and all is well in River
City.

Thanks again for your professional assistance.



John W. Vinson said:
I have a query based on a table./

I have one numeric field that has alphanumber entries: A2000-000;
101010010,A2004, etc..

I what the filter to exclude all records that have an apph beginning - ie.
in eg. above exclude: A2000-000,A2004.
Click to expand...

Use a criteirion of

LIKE "[!A-Z]*"

That is - the first character is NOT (! means NOT in this context) in the
range A to Z, the rest of the string can be anything (*).


John W. Vinson [MVP]
Click to expand...
 
Back
Top