search for: tp4534756p4534756

...where part. my code paste(select * from ", tablename , " where colors in ",paste(var1, collapse=",")) But i'm not able to get required result ----- Thanks in Advance Arun -- View this message in context: http://r.789695.n4.nabble.com/help-in-paste-command-tp4534756p4534756.html Sent from the R help mailing list archive at Nabble.com.

I have data that looks like this: > df1 group id 1 red A 2 red B 3 red C 4 blue D 5 blue E 6 blue F I want a list of the groups containing vectors with the ids. I am avoiding subset(), as it is only recommended for interactive use. Here's what I have so far: df1 <- data.frame(group=c("red", "red", "red", "blue",