Re: [R] RODBC package -- sqlQuery(channel,.....,nullstring=0) stillgives NA's

2005-01-12 Thread Prof Brian Ripley
PLEASE do read the help page, which says nullstring: character string to be used when reading 'SQL_NULL_DATA' character items from the database. ^^^ so this does not apply to numeric items. You can of course easily change numeric NAs to 0s, if you want to. On Wed,

Re: [R] RODBC package -- sqlQuery(channel,.....,nullstring=0)stillgives NA's

2005-01-12 Thread Luis Rideau Cruz
(1) I do read the posting guide (the fact that I missread o missunderstood something does not imply not reading) (2) I could change NAs to 0 (I know) but I have previously (older versions of R and SQL*Plus) used the same select with the right output (namely with 0s). (3) AFAIK strange is not a