Probably going to need to use a cursor or an in memory table. Definitely possible to do what you want but I don't think in straight SQL though.<BR><BR>--The Dan ...