First off, I am not even positive that I need FTS. What I need to do is a search from a phone number column on a parcel phone number. Example:
Dataset: 212-456-7890 212-789-1234 212-564-9875 212-357-8452 212-285-6100 560-851-5522 If searching for a number with '56', I want to get back: 212-4*56*-7890, 212-*56*4-9875, and *56*0-851-5522, NOT 212-28*5-6*100. Is FTS the right answer or is there a quicker faster way? If I do opt to use FTS, which one should I be using, FTS1 or FTS2? According to the web site, it should be FTS1, correct? Sam _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
