Microsoft Office 2000/Visual Basic Programmer's Guide

Comparing Strings

You can compare strings to determine whether they contain equivalent characters and how they differ if they do not match. When you compare two strings, you're actually comparing the ANSI value of each character to the value of the corresponding character in the other string. You can specify whether you want to make comparisons case-sensitive or whether you want to ignore the case and simply compare the strings' characters.