Function to get hostname

["Seth Williams" <swilliams@highstreetnetworks.com>]

Is there any way within an sql query to get the local server's hostname? I am trying to build up a string of 'user@hostname' where the user is defined in a column and the latter is concatenated on.