Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
Returns a value indicating the result of a string comparison.
Syntax
StrComp(string1, string2[, compare])
Arguments
string1
Required. Any valid string expression.string2
Required. Any valid string expression.compare
Optional. Numeric value indicating the kind of comparison to use when evaluating strings. If omitted, a binary comparison is performed. See Settings section for values.
Settings
The compare argument can have the following values:
Constant |
Value |
Description |
|---|---|---|
vbBinaryCompare |
0 |
Perform a binary comparison. |
vbTextCompare |
1 |
Perform a textual comparison. |
Return Value
The StrComp function has the following return values:
If |
StrComp returns |
|---|---|
string1 is less than string2 |
-1 |
string1 is equal to string2 |
0 |
string1 is greater than string2 |
1 |
string1 or string2 is Null |
Null |
Remarks
The following example uses the StrComp function to return the results of a string comparison. If the third argument is 1, a textual comparison is performed; if the third argument is 0 or omitted, a binary comparison is performed.
Dim MyStr1, MyStr2, MyComp
MyStr1 = "ABCD"
MyStr2 = "abcd"
' This is a textual comparison, so the comparison
' is case-insensitive.
' Returns 0.
MyComp = StrComp(MyStr1, MyStr2, 1)
' This is a binary comparison.
' Returns -1.
MyComp = StrComp(MyStr1, MyStr2, 0)
' This is a binary comparison because the last
' argument is omitted.
' Returns 1.
MyComp = StrComp(MyStr2, MyStr1)
Requirements
Change History
Date |
History |
Reason |
|---|---|---|
September 2009 |
Added comments to example. |
Information enhancement. |