Two ways might work, search on both columns by concatenating the columns with a space
WHERE FirstName + ' ' + LastName = 'FORM.searchText' or Split them with a list function WHERE FirstName = 'ListFirst(FORM.searchText, " ")' AND LastName = 'ListLast(FORM.searchText, " ")' Not bullet proof, but a start. Adrian -----Original Message----- From: Mark Brown [mailto:[EMAIL PROTECTED] Sent: 22 February 2007 23:10 To: CF-Newbie Subject: Search Question Hello, I've got a form with two field, on is a drop down box that allows the user to select the search parameters, the other field is to input what the user would like to search on. The drop down box has items like First Name, Last name, or First and Last Name. If the user selects "First and Last Name", the type the full First and last name in the second field, I'm trying to figure out if there is a way to the that one field and split it into two variables to search on, First_Name and Last_name. My database has First Name and Last Name in seperate columns. Does that make sense? Any help you could lend would be greatly appriciated. Thanks, mtbiker ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2589 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
