StrComp

Returns an integer that is the result of the comparison of two strings.

The required String1 argument is any valid string expression. The required String2 argument is any valid string expression.

The optional Compare argument is a numeric expression that specifies the type of string comparison. It can be omitted, 0, or 1. Specify 0 (default) to perform a binary comparison. Specify 1 to perform a textual comparison. If compare is Null, an error occurs.

Syntax

StrComp(String1, String2)

String1:

A string or expression that can represent a valid text value.

String2:

A string or expression that can represent a valid text value.

Return Value

Returns a variant containing an integer data type indicating the result of the string compare:

• Returns -1 where String1 is less than String2.
• Returns 0 where String1 is equal to String2.
• Returns 1 where String1 is greater than String2.
• Returns Null where String1 or String2s Null.

Example

Dim strTest1 as String
Dim strTest2 as String
Dim strTest3 as String
Dim vntComp
strTest1 = "ABCD"
strTest2 = "abcd"
strTest3 = NULL
vntComp = StrComp(strTest1, strTest2) ' Returns -1 (less than) 
vntComp = StrComp(strTest1, strTest1) ' Returns 0 (equal to) 
vntComp = StrComp(strTest2, strTest1) ' Returns 1 (greater than) 
vntComp = StrComp(strTest1, strTest3) ' Returns NULL (strTest3 is NULL)

Published June 2018