Quoting and Escaping Functions

Public Function dq(i As Variant) As String

Same as q() but adds and escapes double quotes.


Public Function q(i As Variant) As String

Adds single quotes around the passed value. Quotes are escaped, so for example if the value O'Leary was passed, the result would be 'O''Leary'. This form of escaping is supported by JET and MSSQL Server. The value NULL returns empty quotes (ie. ''). Using the q() function also protexcts from SQL injection attacks and results in more readable code.


Public Function QuoteByQuoteType(i As Variant, QuoteType As xf_QuoteTypeEnum) As String

Quotes the passed value like q(), but a passed enum is used to work out the quoting type. xf_QuoteTypeEnum: None, SingleQuote, DoubleQuote

Public Function QuoteWithEscape(i As Variant, QuoteChar As String) As String

Quotes the passed value like q(), but using the passed in quote string

Public Function RemoveDateFormatting(s As String) As Variant

Remove single quotes or # characters around a date text value.
No unescaping necessary.


Public Function SqBr(v As Variant) As String

Add enclosing square brackets around the passed string if non empty and isn't already square bracketed

Public Function StripSquareBrackets(s As String) As String

remove enclosing square brackets from the passed string, if present

Public Function Unquote(i As String) As String

Unquote and unescape a single or double quoted string - the reverse of q() or dq(). Automatically determines the quote type by looking at the first character.