Binary Search

<i><b>Originally posted by : Raalnan (Five) (Lettus@HotMail.com)</b></i><br />I have a FoxPro database that I'm accessing throug an ODBC connection. The creators cleverly put in a "SearchMe memo field that collects all data when entered for easy searching. FoxPro keeps its memo fields in binary... The most recent problem with this is that the search is case sensitive. I have tried stepping through the database and changing it to lCase(SearchMe), but so far, the only way I can modify records that I know of is in the SQLStatement. The SQLStatement won't accept functions like LCase... My question is this... Has anyone got a round the problem of searching memo fields in FoxPro. If so, I would be greatly appreciative if you could help me out.

<i><b>Originally posted by : Leonard BenFord (Lettus@HotMail.com)</b></i><br />No answers were posted reguarding the Binary Search, but a simple solution is to just use the OR clause in the SQL. UpperCase OR LowerCase OR ProperCase (ProperCase is a custom function, EMail me if you want it.)