Selecting records on first two words

I have developed a database containg record different items. i want to select all the records that starts with particular word.
example.

I want to select all the records that starts with adm,
This should show all the colums data that start with the word admin. How I should use these in asp runner.

do you mean sort on dropdown box ?

add this on where expression :



"field like 'adm%'"

replace field with your actual field name on database

do you mean sort on dropdown box ?

add this on where expression :



"field like 'adm%'"

replace field with your actual field name on database

thanks for replying. I want that in the search i just want to enter the first two digist of any field of the table from the database and it shows all the records that starts with that two words.

thanks for replying. I want that in the search i just want to enter the first two digist of any field of the table from the database and it shows all the records that starts with that two words.

check this out :

http://xlinesoft.com/phprunner/docs/ajax_features.htm#ajax-pagination

thanks for replying. I want that in the search i just want to enter the first two digist of any field of the table from the database and it shows all the records that starts with that two words.

The ajax based simple search built-in to PHPR already can do this. You may not want to search all columns. You may want to add indices on the columns you do wanna search, like in any database.