I have a column in a table with field type text. However, it contains decimal values like 0.312, 0.445, etc.
I am writing a pretty standard query to get date from my table, but am unsure how I can query decimal ranges given that the field type is text. A sample query:
Do I need to do some kind of math function here?Code:SELECT * FROM myTable WHERE myfield(BETWEEN 0.350 AND 0.450)
Please advise, thanks.