It is possible to use wild card in searching the lookup tables. Our wild card is the % (Percent key). So here are some of its uses in the look up all teams "Name Field":

- run% will retrieve all teams that start with RUN

- %run will retrieve all teams that end with RUN

- %run% will retrieve all teams that contain the 3 letters RUN in a string

- % the Percent by itself will retrieve all teams

- Not using the % symbol will retrieve only those teams that are an exact match to your entry.