Page 5 of 10PREVNEXT

Queries VI: Use wildcards in queries and parameters

Using the question mark in a query

This is where it helps to know your data.

Another common use for wildcards is finding a letter or number that occurs in a specific position in your data. For example, say you want to retrieve all the part numbers for rivets. You know that the part numbers are similar, except for the second character — RC083, RF083, and so on.

To find all the part numbers, you use the question mark wildcard in place of the second character. The picture shows you how. The question mark allows the variable character to appear only in the second position. The rest of the number must match your criteria.

You'll get a chance to try this out in the practice at the end of this course.

Page 5 of 10PREVNEXT