LifeinAsia - 5:09 pm on Jan 14, 2013 (gmt 0)
I didn't know that you could use alphanumeric characters in BETWEEN
Just remember that it's doing a character by character comparison. (So 'AB1234' is actually LESS than 'AB125' even though 125 is less than 1234.)
And I assume you already have an index on productID?