In DB2 I have the requirement of sorting only numeric values from varchar data type column by using some range criteria.
The database table contains numeric as well as alphanumeric values. For ex. `1?, `2?, `6?, `13?, `34? ,?ABC123?, `POE?, `12IUY?, `FG23RF? etc.
Using range search of 1 to 20, result should give `1?, `2?, `6?, `13? values only. I tried using between, < and > operators but it does not give correct results.
Here I don't want to use IN clause.
Any help on building such is highly appreciated.