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
Loading
cechodePosted Nov 21, 2005, 11:33 PM
how about something like
select (lastname + ', ' + firstname) AS fullName from MyTable