>I'd like to find all rows where the time portion of a date_time column is between 11:00AM and 1:15PM.
>
>I seem to get into quite a rat's nest of convert(), datediff() and dateadd() combinations when looking for a simple way to do this.
>
>Thanks,
>Mike

Mike,

Try DATEPART()