>I know of 3 ways to make the desired output. I am not giving them up, though. One version works in any versions of SQL Server and also in FoxPro as well.
I just read a third way - might be the same as yours or might be something different (in which case we have four!)
Let's see what our friend from the Netherlands has. (And hey, maybe even the founder of the Captain Cooker society will weigh in) :)