I have a table tbl_item in which item_id is varchar. when i use the queries below 1 get different results.
Thanks guys for helping. I found the correct way to get this done. The query below was initially giving some issues, don't know why but now it works.
select * from tbl_item where item_id>='1' and item_id<='100' order by item_id