Correct me if I’m wrong, but I do believe that you’ll need to do such field concatenation in the SELECT section of the clause, like so:
SELECT first_name, last_name, first_name + ’ ’ + last_name AS full_name FROM table_name
WHERE first_name = ? OR last_name = ? OR full_name = ?
Jason
