>I see, but he already used named expressions there (in empty use statements) and doing the same SQL N times (where I think N is 7 coming from alen()). I don't understand why he does the same SQL over and over N times if that's his real code. Started to suspect I never could see his original code.
There are seven sets of data files, located in seven different directories (in the real app, it's on seven different servers), representing the data from seven different offices. The task is to select all the records from all of those locations that match the criteria (Cl_Sname="LAWRENCE").