Signature (Visual Basic / VBA)
Public Function EqualCoerceDataType( _
ByVal vOne As Variant _
, ByVal vTwo As Variant _
, Optional ByVal vCompare As Variant _
) As Boolean
Code Examples
EqualCoerceDataType("ALL", "all", vbBinaryCompare) = False
EqualCoerceDataType("all", "ALL", vbBinaryCompare) = False
EqualCoerceDataType("ALL", "all", vbTextCompare) = True
EqualCoerceDataType("3", 3) = True
EqualCoerceDataType(Null, 3) = False
True if vOne = vTwo
False if vOne <> vTwo
Null = Null -> True
Null = Not Null -> False
Empty = Empty -> True
Empty = Nut Empty -> False
Number/Date = Number/Date -> Use numeric comparison.
Number/Date/String = String -> Use string comparison.
vTwo
E N D S
vOne E T F F F
N F T F F
D F F n s
S F F s s
E = Empty
N = Null
D = Date/Numeric
S = String
T = Return True
F = Return False
s = Do String comparison with StrComp
n = Do numeric/Date comparison
Parameters
| Parameter | Description |
|---|---|
| vOne | First of two values which are to be compared for equality. |
| vTwo | Second of two values which are to be compared for equality. |
| vCompare | Specifies the comparison type and sort order/collating sequence used when comparing string values. vCompare defaults to Binary comparisons if it is missing or Null or cannot be fixed up to a number. |
Notes & Version History
| Function returns | See the following table which describes how comparisons are made depending upon data type of arguments. |