Link to home
Start Free TrialLog in
Avatar of Sacha Walter
Sacha WalterFlag for Canada

asked on

Access 2003 query select by number of characters

Hi Experts,

I have a table with a colum containing data such as A, B, C, AA, BB, CC, 1A, AAA, 1AA, BBB, CCC, etc.  How do I utilize the query grid to select records by the number of digits in the field?  For example, if I only wanted to select records containing two characters?
Avatar of mbizup
mbizup
Flag of Kazakhstan image

SELECT *
FROM yourtable
WHERE Len(YourField & "") =2
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial