You can use: SELECT Fname + ' ' + Lname AS FullName
Using single quotes instead of double quotes. You may be able to use: Where FullName = 'Dave Bosky' But some db's won't like that because FullName isn't a real field, so you may need to do: WHERE Fname = 'Dave' AND Lname = 'Bosky' Selene Bainum [EMAIL PROTECTED] Team Macromedia WebTricks http://www.webtricks.com -----Original Message----- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 2:56 PM To: SQL Subject: Combining fields If I have a table called MYNAMES with ID, FName, LName fields how can I use both FNAME and LNAME to match a single variable? Something like select Fname+" "+Lname as FullName from MyNames Where FullName = 'Dave Bosky' Regards, Dave Bosky Sr. Multimedia Web Designer Horry Telephone Cooperative, Inc. office: (843)369-8613 [EMAIL PROTECTED] HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
