On 7/23/2015 10:47 AM, Bernardo Sulzbach wrote:
>> select * from tbl1 where substr(col1,1,1) in ('A','a') and col1 like 'a_c%';
>
> Just adding to Igor's answer:
> col1 between 'a' and 'b' or col1 between 'A' and 'B'
That's not quite the same. BETWEEN is inclusive of both ends. ('b'
BETWEEN 'a' and 'b') is true.
--
Igor Tandetnik
