Re: Searching with one form field

Hi John, You can split out the words from the entry field using lists, for example: CFIF ListLen(EntryField, " ") GT 1 CFSET FirstName = ListFirst(EntryField, " ") CFSET LastName = ListLast(EntryField, " ") CFELSE CFSET Name = #Form.EntryField# /CFIF Nick At 14:02

Re: Searching with one form field

Nick, Thanks a bunch. I figured there was a technique like this, but I just couldn't find it. As it turned out, I figured another route to the same thing. Who is it who's famed for saying, "On the other hand, you could try..."? Dave? I simply added: OR lcase(FN + ' ' + LN) LIKE