Thanks Kurt - I didn't know about that one. I'll store the idea for another time. Cheers, Stuart
-----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kurt Neumann Sent: Thursday, 2 June 2011 19:01 To: U2 Users List Subject: Re: [U2] [UV] Emulate SQL MAX() function at TCL Sorry for the late response, but what about the max keyword i.e. LIST file MAX @ID? It returns the maximum value equivalent to the first value listed in a sort ascending i.e. the justification of the field will affect the order. Regards Kurt Neumann; U2 Certified Solutions Expert _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
