how to handle the LOV

[mfa786]

hi master

first i very sorry for my last mail without rong subject

and

sir i have lov with two column title and code

sir my user need he select the lov by both method
if is press a then lov display which record those start with a
if he press 1 then lov display which record those start with 1
means selection on both field on title and code
if he remember code or remember title

please give me idea how i get both type result

thank
aamir

[mirza_rehan]

Confused question please write yours question again correctly

take care

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family

[admin]

You can use percentage sign (%) to get the result. Like 1% or %ABC. Hope it will work for you.thanks

[mfa786]

thank for your reply
sir i have this is lov query

SELECT CHARTOFACC.TITLE||' '||
CHARTOFACC.ACCID AS comcode FROM chartofacc;

and this is data or column

LAND K1101
BUILDING K1102
COMPUTERS / PRINTERS K1103
OVERHEAD PROJECTORS K1104
MULTIMEDIA K1105

Sir my question
Is where I % % put in my query user only press 1 number or abc string
And get result as per give starting word

thank
aamir

[mirza_rehan]

Where you want to type ??? in any field or on list of values????

please reply

take care
Allah Hafiz

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family

[RiazAhmad]

So simple, when u invoke LOV, if u want to search by first column then put your criteria before % sign in Lov Criteria text box and if you want to search by second column just put your criteria after % sign in LOV criteria text box.