Comparing values

There are many times when you need to compare two values to determine whether or not a particular condition exists. When making a comparison, what you are really doing is making a statement that will either be True or False. For example, the statement "My dog is a cat" evaluates to False. However, the statement "My dog weighs more than my cat" may evaluate to True.

Description

Symbol

Example

Result

Equality

=

5 = 5

True

Inequality

<>

5 <> 5

False

Greater Than

>

6 > 5

True

Less Than

<

6 < 5

False

Greater Than or Equal To

>=

6 >= 5

True

Less Than or Equal To

<=

6 <= 5

False

Text and Boolean values can also be used for comparisons. Text comparisons are case-insensitive and alphabetical. This means that "Steve" and "steve" are equal. But "diane" is less than "steve" because "diane" falls alphabetically before "steve". If you need to make case-sensitive or lexicographic comparisons, you use the String.Compare method like this:

Var dog As String = "Dog"
Var cat As String = "Cat"

Var result As Integer
result = dog.Compare(cat, ComparisonOptions.CaseSensitive)
' result = 1, because "Dog" > "Cat"

To do a case-sensitive comparison:

Var dog As String = "Dog"
Var cat As String = "aCat"

Var result As Integer
result = dog.Compare(cat, ComparisonOptions.CaseSensitive, Locale.Raw)
' result = -1, because "Dog" < "aCat" when case-sensitive

In addition, there is a way to determine whether two floating point numbers are close enough to be considered equal. This is used to account for the imprecision of operations such as floating point division. Use the Double.Equals to do this comparison.

For example, if you are comparing 10000 to a value and specify x=1, then the acceptable values are 10000.000000000002, 10000.0 and 9999.999999999998.

Var d As Double = 10000
Var compareValue As double = 10000.000000000002

If d.Equals(compareValue, 1) Then
  ' take action here...
End If

Logical comparisons

You can test more than one comparison at a time using the And, Or, and Not operators. When passed Boolean values, these operators determine whether the expression is True or False.

And operator

Use the And operator when you need to know if all comparisons evaluate to True. In the example below, if the variable x contains 10 then the expression evaluates to False because 10 is not both greater than 1 and less than 5:

x > 1 And x < 5

Or operator

Use the Or operator when you need to know if any of the comparisons evaluate to True. In the example below, if the variable x contains 10 then the expression evaluates to True:

x > 1 Or x < 5

This is because 10 is greater than 1. The fact that it is not less than 5 does not matter because you only care if at least one of the comparisons is True.

Xor operator

Use the Xor operator when you need to know whether any of the comparisons evaluate to True, but not all of them. In the example below, if the variable x contains 10 then the expression evaluates to True.

x > 1 Xor x < 5

This is because only one of the comparisons is True. However, if x contains 3 then the above expression returns False because both sub expressions are True.

Not operator

Use the Not operator to reverse the value of a boolean variable. For example, this returns True when x is equal to or greater than 0:

Not x < 0

Truth table

A truth table can help you determine what the results of these various comparisons are.

Expression 1

Expression 2

And

Or

Xor

True

True

True

True

False

True

False

False

True

True

False

True

False

True

True

False

False

False

False

False

Bitwise comparisons

Sometimes it is helpful, usually in more advanced situations, to be able to compare the actual bits that make up Integers. You can do this using Bitwise class method comparisons, which work by treating the Integer as a binary number. With a binary number, you can then compare each individual bit to get a new set of bits, which results in a new number.

Bitwise comparisons work with the And, Or and Xor operators when they are used with Integers instead of Boolean expressions.

For example, consider the decimal numbers 5 and 3. Written in binary, they are:

  • 101 (5)

  • 011 (3)

To evaluate 5 Xor 3, you do the comparison on each bit. So for this example:

  • 1 Xor 0 = 1

  • 0 Xor 1 = 1

  • 1 Xor 1 = 0

The new binary value is 110, which is decimal 6.

So this is the final result of the equation: 5 Xor 3 = 6.

The Not operator can also be used to compare Integers. If you pass an integer to Not, it reverses each bit value.

To evaluate Not 5:

  • Not 1 = 0

  • Not 0 = 1

  • Not 1 = 0

The new binary value is 010, which is decimal 2.

Bitwise tables

Results for And, Or and Xor:

Bit 1

Bit 2

And

Or

Xor

1

1

1

1

0

1

0

0

1

1

0

1

0

1

1

0

0

0

0

0

Result for Not:

Bit 1

Not Bit 1

1

0

0

1