Providing an alias with a space in sql

Question

I have a column in my query for which I want to use its name alias .

Currently, it looks like this:

SELECT U.first_name + ' ' + U.last_name UserName,

But I want to use it as below

SELECT U.first_name + ' ' + U.last_name as User Name,

I tried but got an error:

Incorrect syntax next to the keyword "User".

Answer 1

Double quotes for an alias with a space.

SELECT U.first_name + ' ' + U.last_name AS "User Name"

Answer 2

try it

SELECT U.first_name + ' ' + U.last_name as [User Name]