I forgot to mention that the first part of my case statement checks to see if the nsFraction is negative. This can happen even though the overall first date is less than the second date, since the fraction part of the first can still be larger than the fraction part of the second. So I added a case where if the nsFraction is negative, I add it to 1000000000 before casting to varchar. This fixes the problem of a negative nsFraction.

If you can do this with another fix to the query(ies) you showed, that would be very interesting to see.

Thanks...

Bruce