[ic] coordinated search question

[Mat Jones - booksellersolutions.com]

My products DB contains book author names in following format - "LastName,
FirstName"
In the coordinated search I want  user to be able to enter the author in
either "LastName, FirstName" or "FirstName LastName" format.
How can I set the coordinated search to match either format.
Below is part of my coordinated search code:

<FORM ACTION="[area search]" METHOD=POST>
 <input type=hidden name="mv_searchtype" value="sql">
<input type=hidden name="mv_coordinate" value="yes">

<INPUT TYPE=hidden NAME=mv_search_map VALUE="
        mv_searchspec=search1
        mv_searchspec=search2
        mv_searchspec=search3
        mv_searchspec=search4
        mv_searchspec=search5
        mv_searchspec=search6
        ">
 <INPUT TYPE=hidden NAME="mv_search_field" VALUE="author">
 <INPUT TYPE=hidden NAME="mv_search_field" VALUE="title">
 <INPUT TYPE=hidden NAME="mv_search_field" VALUE="publish">
 <INPUT TYPE=hidden NAME="mv_search_field" VALUE="edition">
 <INPUT TYPE=hidden NAME="mv_search_field" VALUE="description">
  <INPUT TYPE=hidden NAME="mv_search_field" VALUE="isbn">

... all html form elements ...
</form>

Thanks

Mat
booksellersolutions.com

Read what the SF Examiner says about booksellersolutions.com:
http://www.sfexaminer.com/business/default.jsp?story=b.web.0121

2141 Mission St #301
San Francisco, CA 94110
(415) 554-0568