Thanks.

I went down this same road about 8 weeks ago - trying to create a check constraint using a UDF, finding it works for inserts but not updates, then finding...

Thanks G^2.

I forgot that I could use filtered indexes in SQL 08. Still. I'm puzzled as to why the constraint behaves this way.

Thanks again,

Mike.