>I would like to do a where on a text field and check if the values have >non-numeric characters, >which is in this case is anything other than 1,2,3,4,5,6,7,8,9,0 or a >space >character. >Is this possible without using a UDF or a very long OR construction?
select * from mytable where mycol glob '*[^0-9 ]*'; _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users