On Fri, 16 Apr 2010 09:32:01 -0700, dar wrote:

Yes, managers are 30 days from hire date, clerks are 90 days from hire date.


That's a business rule.

It's not a database rule.

I can see how you would enforce that in your office, but since you have chosen
not to post any information about your tables, I cannot tell how you would
enforce it in a database.

I'd love to be able to help, but I can't unless you tell me what's in your
database!
--

John W. Vinson [MVP]