1. I did select user_name from user where user_name like '%chandandolui%';
and got two results: Iamchandandolui
and Mr.chandandolui
.
2. I then did select user_name from user where UPPER(user_name) like '%CHANDANDOLUI%';
which ran for about a minute and returned no rows. Shouldn't I get at least the same two rows? I know of at least two more (Chandandolui and Chandandolui1) that should match the case-insens search.
3. If I run select user_name from user where UPPER(user_name) like '%chandandolui%';
, which shouldn't match anything I think, it returns the same two rows as the first case.
I'm a little rusty but what am I missing? —[AlanM1(talk)]— 08:35, 5 September 2020 (UTC)