[R] help in paste command

[arunkumar1111]

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.

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.