Siebel VB Language Reference > VB Language Reference >
StrComp Function
This standard VB function compares two strings and returns an integer specifying the result of the comparison. Syntax
StrComp(string1, string2[, compare])
|
|
string1 |
An expression containing the first string to compare |
string2 |
An expression containing the second string to compare |
compare |
An integer indicating the method of comparison, where: 0 = case-sensitive 1 = case-insensitive |
Returns
One of the following values:
|
|
-1 |
string1 < string2 |
0 |
string1 = string2 |
>1 |
string1 > string2 |
Null |
string1 = Null or string2 = Null |
Usage
If compare is 0, a case-sensitive comparison based on the ANSI character set sequence is performed. If compare is 1, a case-insensitive comparison is done based upon the relative order of characters as determined by the country code setting for your computer. If this argument is omitted, the module-level default, as specified with Option Compare, is used. The string1 and string2 arguments are both passed as variants. Therefore, any type of expression is supported. Numbers are automatically converted to strings. Example
This example compares a user-entered string to the string Smith . Option Compare Text Sub Button_Click Dim lastname as String Dim smith as String Dim x as Integer smith = "Smith" lastname = "smith" x = StrComp(lastname,smith,1) If x = 0 then 'You typed Smith or smith End If End Sub
Related Topics
InStr Function Option Compare Statement
|