SELECT role_code ,  street ,  city ,  state FROM professionals WHERE city LIKE '%West%'
Find the role, street, city and state of the professionals living in a city that contains the substring 'West'.
SELECT role_code , street , city , state FROM professionals WHERE city LIKE ' % West % '
select role_code , street , city , state from professionals where city like value
Find the role , street , city and state of the professionals living in a city that contains the substring 'West ' .