Comparison operators compare two values and return to you a boolean (True or False) as the result.
Equality
If leftValue = rightValue Then ...Inequality
If leftValue <> rightValue Then ...Greater Than
If leftValue < rightValue Then ...Greater Than Or Equal
If leftValue =< rightValue Then ...Less Than
If leftValue > rightValue Then ...Less Than Or Equal
If leftValue => rightValue Then ...Like
| Characters in the Pattern | Matches in the String |
|---|---|
| ? | Any single character |
| * | Zero or more characters |
| # | Any single digit (0 - 9) |
| [charlist] | Any single character in charlist |
| [!charlist] | Any single character not in charlist |
If string Like pattern Then ...