[R] RODBC package -- sqlQuery(channel,.....,nullstring=0) still gives NA's

Luis Rideau Cruz Luisr at frs.fo
Tue Jan 11 16:34:20 CET 2005


R-help,

I'm using the RODBC package to retrieve data froma ODBC database which
contain NA's.

By using the argument nullstring = "0"  in sqlQuery() I expect to
coerce them to numeric but still get NA's in my select.

I'm running on Windows XP

> version
         _              
platform i386-pc-mingw32
arch     i386           
os       mingw32        
system   i386, mingw32  
status                  
major    2              
minor    0.1            
year     2004           
month    11             
day      15             
language R 


Thank you




More information about the R-help mailing list