Validation rules - digits & letters only

C

Carol Shu

Hi, I have a table name [tblVehicle], and a field name [SerialNumber], i set
the validation rule to this field : IS NULL OR NOT LIKE "*[!((A-Z) OR
(0-9))]*", it will accept digits and letters only.
How do you add another validation rule to this, like the letters "I", "O"
and "Q" never appear in a VIN (SerialNumber), thanks.
 
K

KARL DEWEY

UNTESTED ---
IS NULL OR NOT LIKE "*[!((A-H) OR (J-N) OR (P) OR (R-Z) OR (0-9))]*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation Rule 2
validation rule for exactly 5 digits, including leading zeros 0
Validation arguments 3
Validation Rules ? 5
Validation rule for alpha, -, ' 10
Validation Rules 5
Validation Rule for maximum length 6
Validation Rule - Any character outside the range A to Z is rejected. 2

Top