Thanks Ray,
Very clever idea. So I created the search behavior with the 3 searches and bound them to the text box post value, but I'm not sure where you meant to add the spaces. Do I add them to the post value in the behavior?
Here is the behavior currently without any spaces added.
$searchrsNameList_1 = new WA_MySQLi_Search("rsNameList","0=0");
if ((((isset($_POST["name_search"]))?$_POST["name_search"]:"") != "")) {
$searchrsNameList_1->clearSearch();
$searchrsNameList_1->setSearch(array("type"=>"Key", "comparison"=>"Begins With", "join"=>"AND", "and"=>", ", "or"=>" ", "start_encap"=>"\"", "end_encap"=>"\""), array("name"), "s", "".((isset($_POST["name_search"]))?$_POST["name_search"]:"") ."");
$searchrsNameList_1->setSearch(array("type"=>"Key", "comparison"=>"Ends With", "join"=>"AND", "and"=>", ", "or"=>" ", "start_encap"=>"\"", "end_encap"=>"\""), array("name"), "s", "".((isset($_POST["name_search"]))?$_POST["name_search"]:"") ."");
$searchrsNameList_1->setSearch(array("type"=>"Key", "comparison"=>"Includes", "join"=>"AND", "and"=>", ", "or"=>" ", "start_encap"=>"\"", "end_encap"=>"\""), array("name"), "s", "".((isset($_POST["name_search"]))?$_POST["name_search"]:"") ."");
}
Thanks,
TroyD