thanks guys, will give EXCEPT a shot there

regarding the nulls, I don't think so because the imported table is already checked for nulls in that field but it can't help.

regarding hanging on the business... business is...

Thanks darth, wish I'd have found this yesterday!;-)

that worked perfectly, thanks so much for your timely response:w00t:

part of the problem with this Microsoft Press book is that it has some mistakes in it... and it was made for Server Manager, not Server Manager Express...

So, in the...

Thanks for pointing out my sever idiocy... I was not paying attention to the code in the book... the SELECT portion of that trigger should have been

"

SELECT...