Criteria rule with verifying 1st 3 characters of a text

  • 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
 
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
 
The SQL String of your Query should be something like:

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