I had to figure out why I wasn't getting the right answer in my head.
I would look at the select statement and think Ben and David was the answer. I had excluded the other two because the times were equal to the begin and end expressions after rounding. Well, This is why I was getting a different answer.
When using BETWEEN-
"BETWEEN returns TRUE if the value of test_expression is greater than or equal to the value of begin_expression and less than or equal to the value of end_expression."
note: begin_expression >= test_expression <= end_expression
When using NOT BETWEEN-
"NOT BETWEEN returns TRUE if the value of test_expression is less than the value of begin_expression or greater than the value of end_expression."
note: begin_expression > test_expression < end_expressions
Thanks for the question
Forum posting etiquette.[/url] Get your answers faster.