Perform a Starts With

Example:  John% will match John, Johnson, Johns

 

Perform an Ends With

Example: %John will match St. John and John but not Johnson or Johns

 

Perform a Contains

Example:  %John% will match St. John, John, Johnson, Johns

 

You can also use wildcards for the Match Table Names, Exclude Table Names and Match Column Names