Databases with Microsoft Access 9 –Filter Data with Wild Cards and [ ]
Channel: prelearn
Date: 05/07/2016

Square brackets are a placeholder for one character in Access

Within these brackets you can either place specific characters or a whole range of characters you wish to include into your query.

ie
br[ao]wn gets you Brown, Brawn
br[a-d] wn gets you all names that have a, b, c, or d as third letter

Starting off with an ! within your square brackets means that all characters within the square brackets get excluded from your query results.

br[!ao]wn gets you all names except Brown, Brawn
[!w]* gets you all names except those starting with a W