I have a table that contain phone numbers. This table is very large and has an index on ph#.
I have an application that users can query for data using the ph#. They should be able to enter partial phone #
my application has a text box for users to enter the ph# and a combox with the following [equal ,.startwith, endWith]. The phone number is not in a standard format
here an example of the table
Suppose a user is looking for all information where the phone# endwith 3333 . How would I write this query ?. The result should be index = 1 ,2]
I am using SQLITE DB