[R] sqlQuery and string selection

[Jérôme Lemaître]

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.

Any help would be very appreciated,

Thanks a lot

Jérôme Lemaître
Ph.D. student
Départment of biology,
University Laval
Quebec, Canada