The unary operators "!" and "-" do not work for non-numeric columns (for example, varchar type).
However, the "!" and "-" operators work for the ta.pull() function when the values in the varchar column are numeric. Because the underlying RODBC protocol changes the data types when imported to the R environment.