>I was thinking about computed column as well. Seems like James's suggestion of concatenation is the good one (and the one I was going to suggest also),
>
>Unfortunately, this will make our query non-sargable, but I don't see a better way to deal with the problem.
It is in fact an interesting situation. The use of DateTime over the years has simplified all this.