How to force R to not use E as a scientific notation in data.tables

General
5

Yeah makes sense, I've added a sample query below, how would I be able to work around this.

dt = data.table(sqlQuery('odbc',"SELECT '23E5' AS val"))

or

dt = data.table(sqlQuery('odbc',"SELECT CAST('23E5' AS char(4)) AS val"))

here the dt has a column called val but the value is 2300000 instead of 23E5. Even though the variable is a string in the sql query.