Function Comparisons Class

EqualCoerceDataType

Return True if the values vOne and vTwo equal each other, otherwise return False. Attempts to fix-up different types of values to compatible data types.

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.