Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1367

Gow to write this select statement

Show all headers | View raw

Hello!

Is it possible  to write a select statement that return both FName and LName 
as just FullName with a space in between
something like Select (FName  +  "  " + LName) as FullName from employees

So I can use FullName when I bind to a dropdownlist
ddlEmployee.DataSource = backEnd.GetEmployees ();
        C.DataTextField = "FullName ";
        ddlEmployee.DataValueField = "EId";
        ddlEmployee.DataBind();

//Tony 

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Gow to write this select statement "Tony Johansson" <johansson.andersson@telia.com> - 2012-12-09 14:10 +0100
  Re: Gow to write this select statement "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-12-09 08:39 -0500

csiph-web