Hey all

I am trying to use where in clause in sql query in R
here is my code:

sql.select<-paste("select PERSON_NAME from UNITS where UNIT_ID in
('",cathree,"')",sep="")

where cathree is 1 variable with 16 observations as follows

UNIT_ID
1 205
2 209
3 213
4 217
5 228
6 232
7 236
8 240
9 245
10 249
11 253
12 257
13 268
14 272
15 276
16 280

but when i run this code, 0 rows are selected eventhough there exist 3 rows
which satisfy the above query


Thanks
Sneha

	[[alternative HTML version deleted]]

