If you want to do a search with the FullName made out of the combined First and Last name, create a view using the combination that Selene suggested.
Fname + ' ' + Lname AS FullName You can search this. At 02:56 PM 2/26/2003 -0500, you wrote: >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
