Stephan Senzel, on Sunday, February 2, 2020 08:12 AM, wrote...
>
> INSTR() ignores NOCASE on columns
>
> ---
>
> example:
>
> SELECT * FROM table WHERE INSTR(column, ' castle ') > 0
>
> returns datasets with 'castle' only, without 'Castle', even if the
> column is set to
INSTR() ignores NOCASE on columns
---
example:
SELECT * FROM table WHERE INSTR(column, ' castle ') > 0
returns datasets with 'castle' only, without 'Castle', even if the
column is set to NOCASE
---
LIKE doesn't have this problem, works well
SELECT
2 matches
Mail list logo