How Do You Use Keywords In Microsoft Access SQL?
Use the LIKE keyword in Microsoft Access SQL to find an approximate match of data. Open the SQL view window if you want to find the name of a customer in your database but you don’t know the spelling. Type “SELECT” and the name of the columns you want to see. For example: SELECT customerName, customerCity. Press Enter. Type “FROM” and the name of the table containing the columns. For example: FROM customers. Press Enter. Type “WHERE” and the name of the column to which you’ll apply your data limitation. For example: WHERE customerName. Next, type “LIKE” and the first letter of the customer’s name enclosed in single quotes. For example: WHERE customerName LIKE ‘B*’. Add an asterisk after the letter. For example: WHERE customerName LIKE ‘B*’. The asterisk is a wildcard. The wildcard “stands in” for missing letters. This statement will return all customers whose name begins with the letter “b.” Run the query.
