>>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) :)