From: reb01501@NOSPAMyahoo.com   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)