SQLite character Inverse Blur lookup

SQLite a short character to go to the DB Fuzzy Lookup, you can use like

Such as
SELECT * from t_contact where uphone like '%1234% ';

However, when the input string exceeds the length of the database, fuzzy like does not work, at this time, or from the input limit to do fuzzy query, but sometimes this mode can not be changed,
You have to change the search method.
At first common sense with InStr function to test, MAC machine test pass, Real machine report InStr function does not exist
InStr (' 0101234 ', Uphone) not available on iphone

Find another way and make a match with substr. Ok
substr (' 0101234 ', Length (' 0101234 ')-length (uphone)) > 0

SQLite character Inverse Blur lookup