5Jan/050
Comparing StrCompare and @Compare
The StrCompare and @Compare are considered 'Language cross-reference' according to Designer Help. When using the compares you should get the following results:
| Strings being compared | ||
| Either string is NULL | ||
| string1 is less than string2 | ||
| string1 equals string2 | ||
| string1 is greater than string2 |
Now use the following strings and the results are different. The only character that is different is the special characters. I would assume that all non number and letters would have the same reults.
| String1 | String2 | ||
| MailArchivensf | Mailnsf | ||
| MailArchive.nsf | Mail.nsf | ||
| MailArchive!nsf | Mail!nsf | ||
| MailArchive!nsf | Mail!nsf | ||
| MailArchive#nsf | Mail#nsf | ||
| MailArchive5nsf | Mail5nsf |
For now I will be using the following code:
Dim String1 As String, String2 As String
Dim EvalCompare As Variant
Dim CompareResults As Integer
String1 = "MailArchive.nsf"
String2 = "Mail.nsf"
EvalCompare = Evaluate( { @Compare( "} + String1 + {" ; "} + String2 + {" )})
CompareResults = EvalCompare(0)
Dim EvalCompare As Variant
Dim CompareResults As Integer
String1 = "MailArchive.nsf"
String2 = "Mail.nsf"
EvalCompare = Evaluate( { @Compare( "} + String1 + {" ; "} + String2 + {" )})
CompareResults = EvalCompare(0)