sqlh8.1

-- Oefening 1

SELECT LOWER(vend_id)
FROM Vendors;

-- Oefening 2

SELECT cust_contact, CHARINDEX(' ', cust_contact) 
FROM Customers; 

-- Oefening 3

SELECT cust_name, cust_contact
FROM Customers
WHERE SOUNDEX (cust_contact) = SOUNDEX ('Michael Green');