SET ANSI ON SELECT * FROM tbl WHERE '102108' BETWEEN pin_beg AND pin_end Pkx Pin_beg Pin_end 2 10000 11999 17 100000 199999 SELECT * from tbl WHERE VAL('102108') between VAL(pin_beg) AND VAL(pin_end) Pkx Pin_beg Pin_end 17 100000 199999The 2nd SQL statement works correctly but I am not sure why the first one returned two rows. Anyone know why?