Convert a vector to a quoted string for use as a SQL value list
Given a vector, this function returns a string with each element of the input coerced to character, quoted, and separated by ",".
- A vector of values to quote
names is a character vector with elements containing single
quotes, these quotes will be doubled so as to escape the quote in SQL.
A character vector of length one that represents the input vector as a
SQL value list. Each element is single quoted and elements are
Do not use
sQuote for generating SQL as that function is
intended for display purposes only. In some locales,
will generate fancy quotes which will break your SQL.
toSQLStringSet(letters[1:4]) toSQLStringSet(c("'foo'", "ab'cd", "bar"))