SQL Wildcards Accepted in a Table Lookup

For a table lookup with a long list of field values, such as a large office with thousands of employee names listed as potential authors, you can use the filter function at the top left of the table lookup to refine and shorten the list presented.

Enter this wildcard
To see
M*
All values beginning with the letter M.
M?N
All values with M as the first letter and N as the third letter.

Top of page