What I would like to do is calculate the values in the SQL Query instead so that I can sort by those columns. How do I assign values based on other fields to a temporary field name?<P>Hope this ...

You can do the construction of the query columns on the fly, you just can't have the result mapped to a strongly defined type unless you happen to know the full set of columns/types up front and ...

Due to zero-based counting, indexes 1 and 2 map to the second and third columns in the Player table, which are the handle and the emailAddress. When the code builds and runs, the output is as follows: ...