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

Gow to write this select statement

Path	csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From	"Tony Johansson" <johansson.andersson@telia.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Gow to write this select statement
Date	Sun, 9 Dec 2012 14:10:17 +0100
Organization	A noiseless patient Spider
Lines	14
Message-ID	<ka22k2$g3k$1@dont-email.me> (permalink)
Mime-Version	1.0
Content-Type	text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding	7bit
Injection-Date	Sun, 9 Dec 2012 13:10:26 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="da50b8a0e4970e2b9711eebf9392fd1d"; logging-data="16500"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/ER4kb2RI2JdBnfVmfFpOp"
X-MimeOLE	Produced By Microsoft MimeOLE V6.0.6002.18463
X-Newsreader	Microsoft Windows Mail 6.0.6002.18197
Cancel-Lock	sha1:cLiFdN9zdjjuIPQsDC6o5zHHE88=
X-Priority	3
X-MSMail-Priority	Normal
Xref	csiph.com comp.databases.ms-sqlserver:1367

Show key headers only | 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