[R] sqlQuery and string selection

[paul sorenson (sosman)]

(sorry if a duplicate pops through ...)
Jérôme Lemaître wrote:
> Dear alls,
> 
> Could someone tell me how to select a subset of string observations (e.g.
> "females" in a sex column) with sqlQuery in the RODBC library?
> 
> Indeed, I'm trying to select a subset of observations on my access database
> with:
> 
> female<-sqlQuery(mychannel,"SELECT Micromammiferes.sex
> FROM Micromammiferes
> WHERE (((Micromammiferes.sex)="females"));")
> 
> The sql works well in access but in R, I keep getting:
> 
> Error: syntax error.

Most computer software has problems with nested quote characters.

Ie:

 > x = "SELECT Micromammiferes.sex FROM Micromammiferes WHERE
(((Micromammiferes.sex)="females"));"

also results in a syntax error (my mailer split the line).