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

Re: 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	"Bob Barrows" <reb01501@NOSPAMyahoo.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Gow to write this select statement
Date	Sun, 9 Dec 2012 08:39:42 -0500
Organization	A noiseless patient Spider
Lines	17
Message-ID	<ka24ai$p3m$1@dont-email.me> (permalink)
References	<ka22k2$g3k$1@dont-email.me>
Injection-Date	Sun, 9 Dec 2012 13:39:30 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="bd099084a2caba1d0ebe690afacb9523"; logging-data="25718"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18mVLSnZQYIwYTmzmz4+2ByzIn3i7veuiA="
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.2900.6157
X-RFC2646	Format=Flowed; Response
X-Newsreader	Microsoft Outlook Express 6.00.2900.5931
Cancel-Lock	sha1:HT5cnK3SI3mwtjUrvdG3BbHOKk0=
X-Priority	3
X-MSMail-Priority	Normal
Xref	csiph.com comp.databases.ms-sqlserver:1368

Show key headers only | View raw

Tony Johansson wrote:
> 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();
>
Just change the double-quotes to single quotes and you've got it.
SELECT FName + ' ' + LName As FullName from employees

Back to comp.databases.ms-sqlserver | Previous | Next — Previous 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