select user_id, first_name, last_name from ad_template_sample_users where lower(first_name) like '%' || :user_search || '%' or lower(last_name) like '%' || :user_search || '%' select user_id, first_name, last_name, address1, address2, city, state from ad_template_sample_users where user_id = :user_id