upper(CONCAT(first_name,' ',given_name,' ',alias)) like '%first given alias%'
upper(CONCAT_WS(' ',first_name,given_name,alias)) like '%first given alias%'
upper(first_name || ' ' || given_name || ' ' || alais) like '%first given alias%'
upper(CONCAT(first_name,' ',given_name,' ',alias)) like '%first given alias%'
upper(CONCAT_WS(' ',first_name,given_name,alias)) like '%first given alias%'
upper(first_name || ' ' || given_name || ' ' || alais) like '%first given alias%'