I came across a weird issue this morning
while using Between operator am unable to retrieve data that starts with second option,
example am using
select * from USER where vendor between 'N' and 'V'
here i expect to get all the records that has vendor name starting with N,O,P,......U,V
but to my surprise i found am just getting N,O ......,U. am unable to retrieve vendors start with 'V'
when i use between 'N' and 'W' it shows with 'V' also........but not showing vendors with 'W'
so i doubt whether between is considering second option 'V' or not.
Help me with this