Mate you're a lifesaver, i think i can work with that. It's only 1.25am here, so early night tonight. Thanks for your assistance, greatly appreciated.

lol that's what I need to do. Where does the calculation reside and how do I store the result? 

Tks Ninja

Stupid question, but where does the query go? Remembering I need to store the value in SQL Server. I guess not as calculated column. Do I generate the column somewhere in...