>>>>>At this point, I'm just trying to find something that will allow users to select a specific person, short of just browsing the cursor
>>>>
>>>>I repeat my recommendation to change the select statement itself, see my earlier reply. Your Where condition is "dangerous", I don't understand why you stick to it.
>>>
>>>ok, I'm not understanding what is 'dangerous' of
>>>
>>>WHERE Padr(Upper(Lastname),25)+ Padr(Upper(Firstname),25) = Padr(Upper(lname),25) + Padr(Upper(fname),25)
>>>and !Inactive
>>
>>Now you have changed the expression from the one I originally answered to. Anyway, it's a "stupid" expression in my mind. What's wrong with
>>Where Upper(Lastname) = Upper(lname) and Upper(Firstname) = Upper(fname) and !Inactive?
>>Just make sure that the lengths of the compared strings are equal.
>
>With SQL ,lengths would not be a problem if == used instead of =.
>
>IMHO this is a better expression then padr(..)+padr(...), one would likely to have upper(firstName) and upper(lastName) indexes but I doubt for padr(...)+padr(..) - might there be but not preferred.

Right, I forgot that the length was irrelevant, as long as lname and fname are trimmed.