I have one module inthat I have one button .when button pressed It shows the lov.
In the lov i can find record with the help of first column only. but the requirement is "he wants to find the record with any one of the column of lov".
Is this possible.

iam sending all the details.

Table is CITY
columns city_code notnull;
city_name varchar2(30),
state varchar2(30),
country varchar2(30);



In lov QUERY is SELECT CITY_NAME,CITY_CODE,STATE FROM CITY ORDER BY CITY_NAME.

It is very urgent pls send the reply as soon as possible
thanks
rani