I'd either create an additional T field in the table, set that once and normalization be damned for the moment or create a function and call that always in the SQL - deciding by size of table re slowdown through multiple function call which stinks less ;-)

This is not my design and I certainly would have structured the data differently if it had been. This is what I've been given to work with and I am trying to do so.

Thanks.