int = StrCompare(sOne, sTwo, bCaseSensitive)

 

This macro function compares two strings, sOne and sTwo, and returns -1 if sOne is "less" than sTwo, 0 if they are both equal, and +1 if sOne is "more" than sTwo.

 

➢By more and less, we mean the position of each string in an alphabetical listing.

 

This function is used to sort strings.

StrCompare('A', 'Z', false);       // returns -1
StrCompare('AAA', 'aaaa', false);  // returns -1
StrCompare('AAAB', 'aaaa', false); // returns +1
StrCompare('A', 'a', false);       // returns  0
StrCompare('Aaaa', 'aaaa', false); // returns  0

The Boolean parameter, bCaseSensitive, determines if the comparison is to take uppercase and lowercase letters into account.

StrCompare('A', 'Z', true);       // returns -1
StrCompare('AAA', 'aaaa', true);  // returns +1  <---
StrCompare('AAAB', 'aaaa', true); // returns +1
StrCompare('A', 'a', true);       // returns +1  <---
StrCompare('Aaaa', 'aaaa', true); // returns +1  <---

Note that the sort order is determined by the regional settings of Windows on your PC; this has an impact for strings which contain letters such as å æ ø.

 

See also: StrContains.

 

---

Topic 137200, last updated on 18-Apr-2020