-
Step 1
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.
-
Step 2
Type “SELECT” and the name of the columns you want to see. For example: SELECT customerName, customerCity. Press Enter.
-
Step 3
Type “FROM” and the name of the table containing the columns. For example:
FROM customers. Press Enter. -
Step 4
Type “WHERE” and the name of the column to which you'll apply your data limitation. For example: WHERE customerName.
-
Step 5
Next, type “LIKE” and the first letter of the customer’s name enclosed in single quotes. For example: WHERE customerName LIKE ‘B*’.
-
Step 6
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."
-
Step 7
Run the query.
