I would suggest... based on your question... that you should consider the easiest and simplest option (which is usually logically the best)... the multiple update statement route. [ November 01, 2007: Message edited by: Paul Campbell ]