Validation rules - digits & letters only

  • Thread starter Thread starter Carol Shu
  • Start date Start date
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.
 
Back
Top