Glossary Visual Basic / Term
asterisk
A character (*) used as a wildcard in SQL LIKE expressions to accept any string of characters. For example, the expression LIKE "*town*" returns records containing the string "town" followed by zero or more characters.
When you create a query or enter an SQL statement, use the asterisk to include all the fields that currently exist in the underlying table or query. For example, SELECT * FROM MyTable returns all fields (columns) from the table.
Permanent link Asterisk - Creation date 2020-06-07