bob.holbrey (8/5/2008)

---

A really simple option which is able to take advantage that "age" is a number...

Create a table "test" with the following data as shown:

select * from test

NameAgeSex

ABC ...