CITAN (version 2011.08-1)

sqlStringOrNULL: Get nullable character string values for use in an SQL query

Description

Returns trimmed and single-quote-escaped (see sqlEscapeTrim) character strings or "NULL"s on empty input.

Usage

sqlStringOrNULL(value)

Arguments

value
character vector to be processed.

Value

  • The function returns a character vector containing a processed input values and/or "NULL"s.

See Also

sqlNumericOrNULL, sqlSwitchOrNULL, sqlEscapeTrim