Yea that worked !! Did paste(SELECT * FROM MET WHERE molid=", molid, "AND mode=", "\'" mode, "\'" , sep="") I guess all I needed was the sep="" which I totally forgot about.
Cheers, Paul Eric wrote: > Does this work for you? > > "SELECT * FROM data WHERE molNUM = 165 AND mode = '+'" > > Possibly related: when using the paste function, remember that you > might need explicitly set sep = "" and add your own padding where needed. > > Please re-post to the list if it works. > > > > ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.