Criteria with verifying the first 3 characters of a text - how

  • Thread starter Thread starter Rene Wennekes
  • Start date Start date
R

Rene Wennekes

I want to make a querie with a criteria to filter out only the records with
text what begins with "192".

How do I do that?

Rene
 
Like this:

SELECT field1, field2, field3
FROM yourtable
WHERE field1 LIKE '192%';

HTH

Rico
 
I want to make a querie with a criteria to filter out only the records with
text what begins with "192".

How do I do that?

Rene
Click to expand...

Where Left([YourTable].[FieldName],3) = "192"
 
Back
Top