Criteria rule with verifying 1st 3 characters of a text

[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

 

[Tom Lake]

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?

In the Criteria row, specify

Like "192*"

Tom Lake

 

[Van T. Dinh]

The SQL String of your Query should be something like:

SELECT [YourTable].*
FROM [YourTable]
WHERE [YourTable].[RelevantField] Like "192*"