Rocky Ji wrote: > I am asked to highlight rows containing strange characters. All data were > ingested by a proprietary crawler. > > By strange, I mean, question marks, boxes, little Christmas Trees, solid > arrows, etc. kind of symbols; these appear suddenly in flow of normal ASCII > English letters.
GLOB supports character classes: SELECT * FROM MyTable WHERE DataField GLOB '*[^ -~]*'; Question marks _are_ ASCII characters. If you want to allow fewer characters, list them: [^ A-Za-z0-9,.-] Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users