On Apr 5, 2012, at 8:55 AM, arunkumar1111 wrote:
i have a character variable
tablename="DressMaterials"
var1=("red","blue","green","white")
My output should be like
select * from DressMaterialswhere colors in
("red","blue","green","white")
i'm not able to get the where part.
?match
my code
paste(select * from ", tablename , " where colors in ",paste(var1,
collapse=","))
But i'm not able to get required result
David Winsemius, MD
West Hartford, CT
______________________________________________
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.
