WOOD | Returns any records where the surname is WOOD. |
%WOOD | Returns any records where the surname is WOOD or ends in WOOD, i.e. GREENWOOD. |
WOOD% | Returns any records where the surname is WOOD or begins with WOOD, i.e. WOODHOUSE. |
%WOOD% | Returns any records where the surname contains the word WOOD, i.e. WOOD, GREENWOOD, WOODHOUSE. |
WOOD+ | Returns records where the surname is judged to sound alike according to the metaphone algorithm, i.e. WADE. |