Message-ID: <BAY103-DAV172CD27B221B63BB3C544690700@phx.gbl>
Date: 2005-10-19T21:25:31Z
From: Jérôme Lemaître
Subject: sqlQuery and string selection
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