I have had bad data things like this happen but I can always track the error to the application or process that is interacting and populating/modifying the database. I would...

Hi PW,

Thanks for your help and the example of how to code this kind of query properly.

Thanks for the advice. I see that a view is what I should do and the best way to get what I need in this case.

Thanks for the help and comments. I do make use of constraints but I did not think constraints can change data values and from my reading BOL that is where...

Thank you Michelle

Thank you for the reply.

Yes that is what I will do just create the constraint in the design view. Thanks.