SET FILTER using Non-Case-Sensitive searches

[ABQMark]

Howdy guys,

I am using a SET FILTER statement to narrow-down records in my database...When the user inputs the $tring to a field to narrow down, eg. SET FILTER to lname $ "GEER"

The records might contain "Geer","geer",GEER".......

The above SET FILTER pulls out "GEER" and not the others.

I have also SET EXACT OFF because, sometimes they don't have to type the whole search $tring.

an someone tell me how to eliminate this case-sensitivity issue?

If I send lname="GEER", I need to search for ALL possible combinations...Do I need to do a...

SET FILTER TO UPPER(LNAME) $ "GEER"....yikes!

It would be nice to have a SET CASE OFF


Thanks,

Mark Geer

 

[infinitelo]

there is no set case clause that i know of
SET FILTER TO UPPER(LNAME) $ "GEER"
would work fine

 

[tesar]

SET CASE probably not exist,
but to filter geer etc, rather write
SET FILTER TO "GEER" $ UPPER(LNAME),
as former select also "g", "ee", etc