>>also, if this becomes a big deal you can have the dba create a calculated column that combines the two columns into a datetime column.
>
>This cannot be done. But, thanks for the suggestion.
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.
If it's not broken, fix it until it is.
My Blog