>>>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.