SELECT Providers.iid, Providers.lname, ;
iif(UPPER(Providers.lname) = UPPER(?vp_lname),"A","B") as likelymatch,;
FROM rac!providers;
WHERE UPPER(?vp_lname)$UPPER(Providers.lname) ;
ORDER BY likelymatch,Providers.lname

If the lname begins with the string, the choice will be higher in the list, than if the string is contained somewhere in the lname. Using a cascading IIF, you could create a more levels of match likelihood. This example assumes you have set exact off, and uses only two match priorities (begins with AND is contained in)

Otherwise, you could try using the "Create View (viewname) As [select statment]" command to create the view- but it'll be tougher to manager the control sources of your grids if you are constantly deleting and recreating the view definition.