>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*'; 1 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users