format_SQL_in_statement: Format vector of values into a string suitable for an SQL...

View source: R/SDA_query.R

format_SQL_in_statementR Documentation

Format vector of values into a string suitable for an SQL IN statement.

Description

Concatenate a vector to SQL IN-compatible syntax: letters[1:3] becomes ('a','b','c'). Values in x are first passed through unique().

Usage

format_SQL_in_statement(x)

Arguments

x

A character vector.

Value

A character vector (unit length) containing concatenated group syntax for use in SQL IN, with unique value found in x.

Note

Only character output is supported.

Examples

format_SQL_in_statement(c(2648889L, 2648890L))

soilDB documentation built on Sept. 11, 2024, 8:28 p.m.