How to join firstname and lastname

I would like to have a database query that combines both names similar to

SELECT *, UserFirstname + ’ ’ + UserLastName AS UserFullName FROM users WHERE UserID = :security_identity

In other words, a bit of flexibility to create a query would be welcome.