🚀 go-pugleaf

In article <1992Apr13.140116.16963@midway.uchicago.edu> ejw1@midway.uchicago.edu writes:
#>In article <bob.703022897@vincent1.iastate.edu> bob@iastate.edu (Robert P Kuehne) writes:
#>>Hi there.  I'm a novice Foxbase/Mac user.  I like it, but the program is
#>>more complext than I imagined.  Still...have a simple problem:  it seems
#>>that field entries are case sensitive, so that searching requires
#>>knowlege of case.  Is there a way to de-case-sensitize a search, so that
#>>whether I spell with upper or lower, the search will find the
#>>appropriate items.  If you know how to do this, please adivse.  I can't
#>>find the right switch.
#>
#>Sorry, Bob, there is no 'switch' which you can set to turn case-sensitivity on 
#>or off.  No, you have to do everything manually.  You need to use the UPPER() 
#>or LOWER() functions to force the strings to either case and then search on 
#>them.  For example:

An additional suggestion: I also index on UPPER(key) for the
same reason and then SEEK (or FIND) also on an UPPER(expression).
It makes life a bit easier if you choose a convention at the
start and stick to it.

Steve Goldfield