[sqlite] SQL Syntax To Copy A Table

I suggest to use the CloneTable function Have a look at https://www.gaia-gis.it/fossil/libspatialite/wiki?name=CloneTable It copies the table and all of its triggers, indexes, etc. Maurizio 2015-03-26 16:35 GMT+01:00, John McKown : > On Thu, Mar 26, 2015 at 10:29 AM, Nigel Verity > wrote: >>

[sqlite] String compare scoring functions

Hello, I need a function that gives a real result from 0 to 100 representing the similarity of two input strings. I need to compare a dataset of addresses with a dataset of addresses with house numbers, having coordinates, to get a geolocalization of the addresses. Since the addresses aren't