Hi Val

>Steven,

First, my name is not Steven

>Here's one way to achieve this in SQL

Second, he's accessing AS400 not SQL Server

But it's an interesting way of doing it :)