FairCom ISAM for C

Case insensitive partial matches

These examples show how to filter records by comparing against the first N characters of a field while doing case insensitive string comparisons.

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

Case insensitive partial string match

Include records where the first character in a "name" field matches the string "M" or "m" while doing a case insensitive comparison. Matches include "Michael Jordan", "Michael Schumacher", and "Muhammad Ali".

"strnicmp( name, \"m\", 1 ) == 0"

"matchi( name, \"m*\" ) == 1"

Case insensitive partial string non-match

Include records where the first character in a "name" field does not match the string "M" or "m" while doing a case insensitive comparison. Matches include "Babe Ruth", "Pele", and "Wayne Gretzky", but not "Michael Jordan", "Michael Schumacher", and "Muhammad Ali".

"strnicmp( name, \"m\", 1 ) != 0"

"matchi( name, \"m*\" ) == 0"

Case insensitive partial less-than string match

Include records where the first character in a "name" field is less than the string "M" or "m" while doing a case insensitive comparison. Matches include "Babe Ruth".

"strnicmp( name, \"m\", 1 ) < 0"

Case insensitive partial less-than-equal string match

Include records where the first character in a "name" field is less than or equal to the string "M" or "m" while doing a case insensitive comparison. Matches include "Babe Ruth", "Michael Jordan", "Michael Schumacher", and "Muhammad Ali".

"strnicmp( name, \"m\", 1 ) <= 0"

Case insensitive partial greater-than string match

Include records where the first character in a "name" field is greater than the string "M" or "m" while doing a case insensitive comparison. Matches include "Pele" and "Wayne Gretzky".

"strnicmp( name, \"m\", 1 ) > 0"

Case insensitive partial greater-than-equal string match

Include records where the first character in a "name" field is greater than or equal to the string "M" or "m" while doing a case insensitive comparison. Matches include "Michael Jordan", "Michael Schumacher", "Muhammad Ali", "Pele" and "Wayne Gretzky".

"strnicmp( name, \"m\", 1 ) >= 0"