Re: [R] Where Query in SQL

Do this cat(sql.select,'\n') and then decide whether the query is what it should be according to standard SQL syntax. (If it is not, then fix it.) -Don -- Don MacQueen Lawrence Livermore National Laboratory 7000 East Ave., L-627 Livermore, CA 94550 925-423-1062 On 6/10/13 11:47 AM, "Sneh

[R] Where Query in SQL

Hey all I am trying to use where in clause in sql query in R here is my code: sql.select<-paste("select PERSON_NAME from UNITS where UNIT_ID in ('",cathree,"')",sep="") where cathree is 1 variable with 16 observations as follows UNIT_ID 1 205 2 209 3 213 4 217 5 228 6 232 7 236 8 240 9 245 10 2