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 * FROM table WHERE column LIKE '% castle %'
returns 'castle' and 'Castle' when column is set to NOCASE
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users