How to use the LIKE clause in SQL Query in MS Access

This article will show you how to use the LIKE clause in SQL to search all the related records in a table that begin with, end with or contain a certain letter.

Normally for LIKE statement, the wildcard character is “%”, but please take note that, in MS Access, you have to use the wildcard “*” instead of “%”, else it is not working.

Here are some examples using the LIKE clause:

LIKE [First character that you want to search] & “*”
LIKE “*” & [Certain character that you want to search] & “*”