|Since it's the same table you can just write it like this:
, CONCAT(BFirstName, ' ', BLastName) AS BAttention
WHERE CardID = 1121
If you're thinking about null-values:
jkirkerx wrote:not sure if it's safe
Quote:Null values are implicitly converted to an empty string. If all the arguments are null, an empty string of type varchar(1) is returned.
So you might want to surround the CONCAT(..) with a TRIM(..).
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson