Calculated fields in tables

[efratk]

I would like to create a table that one of it's fields is calculated according to other fields. Is there a way to do it?
For example:
Field a - expirationDate
Field b - isDeleted
Field c should be the status and calculated as follows: if isDeleted=1 should be "deleted" if expirationDate < NOW() should be "expired" else should be "active".

[sicarie]

Is this another database question? If so, you should ask it in the appropriate database forum, depending on what you are using...