merging two fields in a table in sqlserver2k

Nov 21 2005 12:10 AM
good morning everybody
i have 3 fields in empdetails table . fields are firstname , middlename, lastname.
now i want to retrive the firstname with lastname and place it into a dropdownlist in  C# page.
so how could i write the query in sqlserver2k
advance thanks
sarma

Answers (1)