R help - Apr 2012 - help in paste command

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.

Hello Arun,
> paste("select * from ", tablename , " where colors in
(",paste(var1,collapse=","),")")
[1] "select * from  DressMaterials  where colors in (
red,blue,green,white )"

Regards!

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

Thanks Lell

It worked well.

-----
Thanks in Advance
        Arun
--
View this message in context:
http://r.789695.n4.nabble.com/help-in-paste-command-tp4534756p4534925.html
Sent from the R help mailing list archive at Nabble.com.