If you are using Visual Basic, the MSDN CD is a good place to look for SQL syntax--although it's a little light on examples. Here is a link to an online reference that may be helpful: http://torresoft.netmegs.com/

To address your immediate need, try...

Code:
Dim sSQL as String

sSQL = "SELECT Firstname & ' ' & Lastname AS Thename FROM YourTable WHERE Thename = '" & cboName.Text & "'"
Gerald M.


[This message has been edited by Gerald (edited 12-13-1999).]