I have two columns. I am combining these two columns using Select ( FirstName + LastName) AS Name and assigning the datasource to a listbox.
The listbox shows the data without any space between the first and last name.
Is there a way to insert a space between the FirstName and LastName columns using a sql query so that the list box displays the result as
( FirstName LastName )
Thanks,
Salil.
View Complete Post