SELECT id + '|' + FirstName  + '|' + Surname
FROM some_table
WHERE ....