Hi people.
In 10.6 our users run an ADHOC query to identify which records they have touched during the day to produce labels to post out their results..
In this case the Name_Results_Summary table where their username is entered into the table in the updated_by field.
Here is the username element fo the adhoc..
Name_Results_Summary.UPDATED_BY = Substring(user_name(),1,Case when charindex('_',user_name()) > 0 Then charindex('_',user_name())-1 Else len(user_name())End )