Hi, BETWEEN for VARCHAR type field.
My employer asked me to debug a part of the app. and it is written by a co-worker.
In the buggy query I found this in the table :
and in the query:
This conditions :
"BETWEEN 0 AND 30" return the results thar are >0 and <30, and other results that have in the field chars (like "No payment"). I can't change the table structure because the app. is very big. I need a work around.
Do you know haw I can make this query to work ?
If I search "BETWEEN 0 AND 30" it will give me only the results that have the 'notice_period' BETWEEN 0 AND 30 and not the rows that have other text in it ?
Thank you for the time,