TextValue

Syntax

SQL.TextValue(Nork[, UseWildCards][, UseRTF])

Description

Converts a string value to a string value in formatted SQL text, including optional wildcards.

Parameter	Description
Work	String, The text to be edited to SQL formatting
UseWildCards	Optional. If TRUE, wildcards are added to the markup, for use in searches.
UseRTF	Optional. If TRUE, tabs, line breaks, tabs and page breaks are translated into RTF control codes.

See Also

DateValue, NumberValue

Example

Sub Main()
 
    MsgBox SQL.TextValue("Wat 'n mooie dag", True)
 
    ' "'%wat ''n mooie dag%'"
 
    MsgBox SQL.TextValue("Prijs:" & Chr$(9) & "123,34" & _
         vbNewLine & "------" & Chr$(9) & "------", , True)
 
    ' "'Prijs \tab 123,34 \par ------ \tab ------'"
 
End Sub