I have a DBase IV table and am attempting to run a like query on it similar to below
ex.
Select * From Tablename Where Title like example%
the like statement doesn't make good use of the index so for speed reasons I have changed to
Select * From Tablename Where Title between "example" and "exampleZZZZZZZZZZZZZZZZZZ
ZZZZ"
now I want to write a query where the case of "example" could be anything ie EXAMPLE, ExAmPLE, Example, etc... but my select statement will still grab everything that starts with example. Is there a fast way to do this, or if not what are the ways to do this?
Start Free Trial
