shashi bhushans wrote:i used Ajax in my projects similar to Google search. in Google when you type starting letters, remaining letters will drop down. like that i used in my projects . output is coming. in asset_id column values are like this (a) 1101aaa0001 (b) 4101acd0001 (c) 5204hog0001. when i type 1 in text field it is displaying all values from asset_id column.. if i type 1 it should display which are all starts from 1.
query: SELECT ASSET_ID FROM DETAILS_MASTER_ASSET WHERE ASSET_ID like ? after like some pattern matching should be there.
asset_id is varchar data type
Try with
query: SELECT ASSET_ID FROM DETAILS_MASTER_ASSET WHERE ASSET_ID like
"<typedString>%"
denitu