Function Convert Values Class

EqualQuotedValue

Returns the string expression which can be used within a Microsoft SQL WHERE clause to search for the value vValue.

Signature (Visual Basic / VBA)

Public Function EqualQuotedValue( _
    ByVal vValue As Variant _
    ) As Variant

Code Example

    EqualQuotedValue(CLng(1)) = "= 1&"
    EqualQuotedValue(CSng(2)) = "= 2!"
    EqualQuotedValue(CBool(0)) = "= False"
    EqualQuotedValue("Al") = "= ""Al"""
    EqualQuotedValue(Null) = "Is Null"

Parameters

Parameter Description
vValue The value which is to be turned-into a string expression.