>I am not an expert on this, but it does seem to me that the third option will reduce network traffic - the calculated fields are calculated by the client.

Hilmar,

As I was asking this question to a coworker, I talked myself out of the first two options anyway. ;) Option 1 because you can't write to the calculated fields. Option 2 because it would make the stored procs messy. So, I guess the heart of my question is where is the best place to put these properties? I'm thinking of creating a class with 7 properties and putting an instance of that class on the DataRow. This would make access look like this:

oDataRow.WeekDays.Tuesday = false;

And that would set the 5th bit of oDataRow.nDayOfWeek to a one.

Is this a good (right) way to do it?

TIA,
Chad