search for: 1881501224_2

...an identifier; not a number). Reading this into R gives cowidp 1 1881501224 2 1881501224 .... - i.e. the ".2" is stripped off - and it becomes a numeric variable However, if I store replace "." with "_" in my SAS data then the column in my database is cowidp 1881501224_2 1881501224_2 Reading into R gives cowidp 1 1881501224_2 2 1881501224_2 as it "should be" - it becomes a factor Is the fact that the "."-part does not seem to work a bug in sqlQuery (or somewhere else) or is it the intention that things containing a "." a...