01 | -- Oefening 1 |
02 |
03 | SELECT prod_name |
04 | FROM Products |
05 | WHERE prod_name LIKE 'FISH%'; |
06 |
07 | SELECT prod_name |
08 | FROM Products |
09 | WHERE prod_name LIKE 'F%y'; |
10 |
11 | -- Oefening 2 |
12 |
13 | SELECT cust_contact |
14 | FROM Customers |
15 | WHERE cust_contact LIKE '[JM]%'; |
16 |
17 | -- Oefening 3 |
18 |
19 | SELECT prod_name |
20 | FROM Products |
21 | WHERE prod_name LIKE '__ inch teddy bear'; |
Download hier het bestand.