Gert Van Assche wrote: > is there a way to find all records where a field only contains non-alpha > numeric characters, or numbers?
This description is rather vague. The following finds values that do not contain alphabetical characters: SELECT * FROM MyTable WHERE AField NOT GLOB '*[^A-Za-z]*' Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
