Hello Arun, > paste("select * from ", tablename , " where colors in (",paste(var1,collapse=","),")") [1] "select * from DressMaterials where colors in ( red,blue,green,white )"
Regards! ______________________________________________ R-help@r-project.org 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.