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

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
 
R

rico

Like this:

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

HTH

Rico
 
F

fredg

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"
 
Top