Public Function QuoteString( _ ByVal vValue As Variant _ , Optional ByVal vQuoteChar As Variant _ ) As Variant
QuoteString("Joseph 'Joe' Marks", "'") = "'Joseph ''Joe'' Marks'" QuoteString("12345", "'") = "'12345'"See also:
DoubleQuoteString Function EqualQuotedValue FunctionvValue: The string which is to be quoted. Function returns Null if vValue is Null or cannot be fixed up to a String.
vQuoteChar: The character (or string) which is to be used to quote the string vValue. vQuoteChar defaults to an empty string if it is missing or Null or cannot be fixed up to a String. i.e. vValue will be returned in string form but with no quote characters added.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.