What code do you like the most, left or right? See screenshot in link below:
Please elaborate why? I'm very interested in the answers.
I would always use a FOR FIRST instead of a FIND or FIND FIRST (no need to use NO-ERROR). At least for MSSQL connected databases through the dataserver FOR FIRST include the SELECT ... TOP 1 phrase compared to a simple FOR, which result in a performance benefit.