Assume a table containing the following entries for itemNum:

B2456DI14
B2456DI14R
B2456DI14TT
B2456DI14W

select * from itemMast ;
    where itemnum >= "B2456DI14" and itemNum <= "B2456DI14"

The SQL Select returns all four of those records. However if I go to the any of them besides the first record, and do:

? (itemNum >= "B2456DI14" and itemNum <= "B2456DI14")  && shows FALSE

Trying to make a parameterized view that can get a range of records, or only one record if start and ending values are the same. But it is a bust at this point.

Any ideas?