Can i select two attributes and display them as one column in the gridview using sql statement? Part 2?

i still cant figure it out....





';SELECT [LastName] 'Name' FROM [User]';;





how to display both the LastName and FirstName at the same time?Can i select two attributes and display them as one column in the gridview using sql statement? Part 2?
Under oracle it works like this:





SELECT LastName || Name FROM Users;





or





if you want to add your own string:





SELECT 'your own string' || LastName || Name FROM Users;Can i select two attributes and display them as one column in the gridview using sql statement? Part 2?
SELECT [FirstName] + ' ' +[LastName] AS [Name] FROM [User]
';SELECT LastName + ', ' + [Name] FROM [User];';;