FairCom ISAM for C

Case insensitive matches

These examples show how to filter records by comparing a field value to a constant string while doing a case insensitive comparison. For example, the following strings match each other when doing a case insensitive comparison: "Pele", "pele", "PELE", "PeLe", "pELE", "pElE", and so forth.

In This Section Case insensitive string match Case insensitive string non-match Case insensitive less-than string match Case insensitive less-than-equal string match Case insensitive greater-than string match Case insensitive greater-than-equal string match

Case insensitive string match

Include records where the value of a "name" field matches with the string "pele" while doing a case insensitive comparison. Matches include "Pele" and "PELE" .

"stricmp( name, \"pele\" ) == 0"

"strnicmp( name, \"pele\", 4 ) == 0"

"matchi( name, \"pele\" ) == 1"

Case insensitive string non-match

Include records where the value of a "name" field does not match the string "pele" while doing a case insensitive comparison. Matches include "Michael Jordan", and "Babe Ruth".

"stricmp( name, \"pele\" ) != 0"

"strnicmp( name, \"pele\", 4 ) != 0"

"matchi( name, \"pele\" ) == 0"

Case insensitive less-than string match

Include records where the value of a "name" field is less than the string "pele" while doing a case insensitive comparison. Matches include "Michael Jordan", and "Babe Ruth".

"stricmp( name, \"pele\" ) < 0"

"strnicmp( name, \"PELE\", 4 ) < 0"

Case insensitive less-than-equal string match

Include records where the value of a "name" field is less than or equal to the string "pele" while doing a case insensitive comparison. Matches include "Pele", "Michael Jordan", and "Babe Ruth".

"stricmp( name, \"PeLe\" ) <= 0"

"strnicmp( name, \"pele\", 4 ) <= 0"

Case insensitive greater-than string match

Include records where the value of a "name" field is greater than the string "pele" while doing a case insensitive comparison. Matches include "Wayne Gretzky".

"stricmp( name, \"pElE\" ) > 0"

"strnicmp( name, \"pele\", 4 ) > 0"

Case insensitive greater-than-equal string match

Include records where the value of a "name" field is greater than or equal to the string "pele" while doing a case insensitive comparison. Matches include "Pele" and "Wayne Gretzky".

"stricmp( name, \"PELE\" ) >= 0"

"strnicmp( name, \"pele\", 4 ) >= 0"