>is anybody aware of a possibility to do s.th. like
>select * from table where field like '[A|a]%'

Unless non-standard compile option and provided you don't issue
     PRAGMA case_sensitive_like = 1;
LIKE is case-insensitive, so LIKE 'A%' is the same as LIKE 'a%'

SQLite offers another filtering function: GLOB, which is case-sensitive 
and can accept '*', '?' wildcards (instead of LIKE' % and _) and a 
regexp-style character subset for selection '[a-z]' or exclusion '[^0-9]'.

select 'abcd123' glob '*[Cc]?[1-9]2*';

sqlite-users mailing list

Reply via email to