hi, use paste: # a string/number/date pn <- '39R5238'; sql <- paste("select u.unitid from test where part =", pn) ^^
# an array of strings/numbers/dates pn=c(1,2,3,4) sql <- paste("select u.unitid from test where part in (", paste(pn, collapse=','), ")") ^^ regards soren obs the use of '=' and in ----- Original Message ----- From: "Thorsten Muehge" <[EMAIL PROTECTED]> To: <r-help@stat.math.ethz.ch> Sent: Thursday, October 05, 2006 9:35 AM Subject: [R] Variables in RODBC environment > > Hello Experts, > how can I use variables in the RODBC environment. > > Example which does not work: > > Thanks for your help. > > Thorsten > > pn <- '39R5238'; > > library(RODBC); > odbcobj <- odbcConnect("SQUIT21C",uid="muehge",pwd="xxx"); > sql <- "select > u.unitid, > from test > where part in ('pn') > "; > parameter <- sqlQuery(odbcobj,sql); > odbcClose(odbcobj); > > ______________________________________________ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.