Hello everyone,
Has anyone come up with a decent autocomplete function? And by this I mean a funtcion that allows the user to search a list alphabetically, as with Google suggest, as oppsed to simply using wildcards and the SQL Like function?
I've been looking around but to no avail....
Any help is appreciated.
j
I have to answer my own question here, which, in a way, illustrates a certain level of incompetence on my part. To search a list of names, for example, using sql alphabetically, one could use the like function as follows"
Select from names where name like 'a%'
This will return all names that begin with the letter a.
j
2 more cents
Select from names where name like 'a%'
if you have more than just first name, you can also use '%a%' to look for substrings