Object Reference

Classes
Command Interface
- xf_Command
External
- xf_External_VB6_32bit
- xf_External_VB7_32_64bit
General
System Core
System Library

xf_StringCaseSensitiveString Functions

Compare variant values

Public Function CompareValue(field1 As Variant, field2 As Variant, Optional SortDirectionAsc As Boolean = True) As Integer

Compare two possibly Null valued variables.
Returns 0 if equal, 1 if field1 is greater than field2, and -1 if field1 is less than field2 Null is always less than any non-Null value

Public Function ValueEqual(field1 As Variant, field2 As Variant) As Boolean

Check if two possibly Null valued variables are equal.

Public Function ValueLike(field1 As Variant, field2 As Variant) As Boolean

Check for match of two possibly Null valued variables using 'Like'.
The values must be either string or Null.