StrComp: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 36: | Line 36: | ||
[[Category:Language Reference]] | [[Category:Language Reference]] | ||
[[Category:Strings]] |
Revision as of 18:57, 11 September 2012
StrComp(string1, string2[, compare])
Description
StrComp compares two strings and returns an integer value which indicates the alphabetical relationship between them. The required parameters, string1 and string2, are two valid string expressions. The optional parameter, compare, is used to specify the type of comparison performed. StrComp returns -1 if string1 is less than string2, 0 if string1 is equal to string2, or 1 if string1 is greater than string2.
Example
Rem StrComp Example 'StrComp compares two strings Sort "Kenny", "Kyle", vbBinaryCompare Sort "Eric", "eric", vbTextCompare Sort "Wendy", "Stan", vbBinaryCompare Sub Sort(string1, string2, compare) Dim Order Order = StrComp(string1, string2, compare) If Order < 0 Then Print string1 & " precedes " & string2 ElseIf Order > 0 Then Print string2 & " precedes " & string1 Else Print string1 & " and " & string2 _ & " are equivalent" End If End Sub
Output
Kenny precedes Kyle Eric and eric are equivalent Stan precedes Wendy