Usually when we concatenate two fields like firstname and lastname we use ‘ ‘ between them like below
select firstname + ' ' + lastname from tblEmployee
And if we want more space then we use long space between them, but sql server provide function for print space between query.
Syntax:
SPACE(NO)
For example
select firstname + SPACE(2) + lastname from tblEmployee
It will return like below.
Viral Sarvaiya
Thanks.
Enjoy..
