[R] help in paste command

[David Winsemius]

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