jeudi 13 août 2015

How to add 'n' number of spaces between two Column names in Query?

I am trying to write a basic query which gives me FullName from columns FirstName & LastName

Query:

select StudentID,
    FirstName + ' ' + LastName as FullName
from Students

Now i am interested to see is there any chance we can add spaces between FirstName & LastName in query while joining dynamic ?

per say i need to have 50 spaces between FirstName & LastName ? Can i achieve this.

one solution would be adding spaces manually which does look the way to go here .



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire