I want to get records from a db based on "category"-field, which is string typed but it contains mostly numeric data, some exceptions excluded. Let's say that the categories that we need to get are from 1 to 3, and we have categories from 1 to 99 in the db.
I get the data ok, but the problem is, that when i evaluate string fields with >= and <=, the results include category 10 too, since it fits in the statement "1 to 3" somehow, based on alphabetical comparison maybe?
Any ideas how to solve this?
I get the data ok, but the problem is, that when i evaluate string fields with >= and <=, the results include category 10 too, since it fits in the statement "1 to 3" somehow, based on alphabetical comparison maybe?
Any ideas how to solve this?