You wouldn't know off hand if it works in MSSQL Server? Regards,
Dave Bosky Sr. Multimedia Web Designer Horry Telephone Cooperative, Inc. office: (843)369-8613 [EMAIL PROTECTED] -----Original Message----- From: Selene Bainum [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 3:10 PM To: SQL Subject: RE: Combining fields 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
