How to give a single space in sqlserver query

Question

0.00/5 (No votes)

See more:

hi frnds,

am working on gridview data is displaying from Sqlserver database.

I want to give space in column.

According to my Code and query it is

Select FL_Name as FullName,Fn_Name AS FirstName,Ln_Name AS LastName from Emp

But i need space, it must be like this Full Name, First Name, Last Name.

Please can you help me, how to give space in between single column.

Thanks...

Posted 5-Feb-14 0:08am

Member239258

Add a Solution

5 solutions

Solution 3

Try Select FL_Name as FullName ,' ' , Fn_Name AS FirstName,' ', Ln_Name AS LastName from Emp

Posted 5-Feb-14 0:14am

Abhinav S

Solution 5

hello
forexample:-

select First_Name as "Full Name",First_Name AS "First Name",Last_Name as 'Last Name' from tbl_User

Posted 5-Feb-14 0:20am

ssss0001

Updated 5-Feb-14 0:35am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Er. Ajay Chauhan · Accepted Answer · 2014-02-05T00:13:00

Solution 1

try this one, it would be helpful...

SQL

Select FL_Name as "Full Name",Fn_Name AS "First Name",Ln_Name AS "Last Name" from Emp

;-)

Posted 5-Feb-14 0:13am

Er. Ajay Chauhan

OriginalGriff · Accepted Answer · 2014-02-05T00:13:00

Solution 2

Try:

SQL

SELECT FL_Name AS [Full Name],Fn_Name AS [First Name],Ln_Name AS [Last Name] FROM Emp

Posted 5-Feb-14 0:13am

OriginalGriff

Comments

Ankur^\m/ 5-Feb-14 6:21am

Wtf?! 1? Countering.

Member239258 5-Feb-14 6:28am

Thanks.

OriginalGriff 5-Feb-14 6:36am

You're welcome!

Member 10322562 · Accepted Answer · 2014-02-05T00:15:00

Solution 4

Select [Full Name] = FL_Name ,[First Name] = Fn_Name ,[Last Name] = Ln_Name from Emp

Posted 5-Feb-14 0:15am

Member 10322562

Updated 5-Feb-14 0:16am

v2

Comments

Ankur^\m/ 5-Feb-14 6:22am

Incorrect vote countered.