Results 1 to 2 of 2
Oct 14, 2009, 06:13 #1
- Join Date
- Jun 2007
- 0 Post(s)
- 0 Thread(s)
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 :
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,