Simple Fiedls Combination Question ???

Dear all,

I have the follwing procedure:



Code Snippet
ALTER PROCEDURE [dbo].[Read_Current_User]
-- Add the parameters for the stored procedure here
@LoginUserName varchar(50) OUTPUT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- get current user name
SET @LoginUserName=(SELECT [NomosConfig].[dbo].[Users].[UserName]
,[NomosConfig].[dbo].[Users].[Id]
,[NomosConfig].[dbo].[Users].[FirstName]
,[NomosConfig].[dbo].[Users].[LastName]
,[NomosConfig].[dbo].[Users].[Email]

FROM [NomosConfig].[dbo].[Users]
WHERE [NomosConfig].[dbo].[Users].[LoggedIn]=1


END




How can I set my @LoginUserName output parameter to be a combination of fields [NomosConfig].[dbo].[Users].[FirstName] + [NomosConfig].[dbo].[Users].[LastName] ?

As a result I should get @LoginUserName = FirstName + ' ' + Lastname


Thanks
regards
serge