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