quick SQL reference for A9.3

WHERE CustomerName LIKE 'a%'           Finds any values that start with "a"

WHERE CustomerName LIKE '%a'           Finds any values that end with "a"

WHERE CustomerName LIKE '%or%'      Finds any values that have "or" in any position

WHERE CustomerName LIKE '_r%'         Finds any values that have "r" in the second position

WHERE CustomerName LIKE 'a_%'         Finds any values that start with "a" and are at least 2 characters in length

WHERE CustomerName LIKE 'a__%'      Finds any values that start with "a" and are at least 3 characters in length

WHERE ContactName LIKE 'a%o'            Finds any values that start with "a" and ends with "o"