sqlIn: Create a List for SQL IN Clauses

Description Usage Arguments Examples

View source: R/sqlIn.R

Description

This function allows you to take a vector and turn it into a character string containing a comma separated list, bookended by parentheses, for use in an SQL IN clause.

Usage

1
sqlIn(vect, type = "char")

Arguments

vect

A vector you want to use in an SQL IN Clause type Either "num" for numeric or "char" for character. "char" will put single quotes around each value in the list so the query will be process the values as strings. Defaults to "char".

Examples

1
2
sqlIn(mtcars$mpg, type = "num")
sqlIn(iris$Species)

spenceredwin/sqlWriteR documentation built on Sept. 13, 2019, 1:36 p.m.