Thanks Clements, that does the trick indeed!
2013/6/12 Clemens Ladisch <clem...@ladisch.de> > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
