Another idea would be to use an indexed view, which would only need to be updated when the source data was updated. You then could overload the field names...

Hmmm, interesting idea. I haven't used computed persistant columns much so I'll have to look into that more, however it would my my queries much simplier again.

Quick question, can...

Thanks for the reply, and your right none of that sounds easier.

Right now it isn't a one off, but if speed becomes and issue I might need to force it...