How to add two different columns data in one columns from SQL server and C#

By using LTRIM();

string commnd = "select id,(LTRIM(FirstName)+' '+Ltrim(LastName)) as [Name],Date_of_Birth,Email_id,Phone_no,Postal_Address,imgURL from Candidate_Info where id=" + id;

Thats all...