>>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.