Name
Option Compare Statement
Syntax
Option Compare {Binary | Text}Description
Used to set the default method for comparing string data
Rules at a Glance
When
OptionCompareis not used in a module, the default comparison method is Binary.When
OptionCompareis used, it must appear at the start of the module’s declarations section, before any procedures.Binary comparison — the default text comparison method in Visual Basic — uses the internal binary code of each character to determine the sort order of the characters. For example,
"A"<"a".Text comparison uses the locale settings of the current system to determine the sort order of the characters. Text comparison is case insensitive. For example,
"A"="a".
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access