format_SQL_in_statement

Concatenate a vector to SQL <code>IN</code>-compatible syntax: <code>letters[1:3]</code> becomes <code>('a','b','c')</code>. Values in <code>x</code> are first passed through <code><a href="/link/unique()?package=soilDB&version=2.8.8" data-mini-rdoc="soilDB::unique()">unique()</a></code>.

A collection of functions for reading soil data from U.S. Department of Agriculture Natural Resources Conservation Service (USDA-NRCS) and National Cooperative Soil Survey (NCSS) databases.

Andrew Brown

soilDB

Soil Database Interface

Dylan Beaudette

Jay Skovlin

Stephen Roecker

format_SQL_in_statement function

<dl><dt>x</dt>
<dd>A character vector.</dd></dl>

Arguments

Concatenate a vector to SQL <code>IN</code>-compatible syntax: <code>letters[1:3]</code> becomes <code>('a','b','c')</code>. Values in <code>x</code> are first passed through <code><a href='https://rdrr.io/r/base/unique.html'>unique()</a></code>.

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

<dl>

<dt>x</dt>
<dd>A character vector.</dd>

</dl>

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

Description

Usage

Value

Arguments

Examples