SELECT role_code ,  street ,  city ,  state FROM professionals WHERE city LIKE '%West%'
Which professionals live in a city containing the substring 'West'? List his or her role, street, city and state.
SELECT role_code , street , city , state FROM professionals WHERE city LIKE ' % West % '
select role_code , street , city , state from professionals where city like value
Which professionals live in a city containing the substring 'West ' ? List his or her role , street , city and state .