Criteria rule with verifying 1st 3 characters of a text

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
 
T

Tom Lake

Rene Wennekes said:
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?
Click to expand...

In the Criteria row, specify

Like "192*"

Tom Lake
 
V

Van T. Dinh

The SQL String of your Query should be something like:

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