SQL Query: Finding Records Between Datetime Inside Datetime

Hey :)

I'm facing a lot of troubles trying to create a new pause/break-system. Right now i'm building up the query that counts how many records that is inside 2 fields. Let me first show you my table:

ID (int)     |    stamp_start (Type: DateTime)        |      stamp_end (Type: DateTime)           |      Username (varchar)
0             |      17-03-07 12:00:00                      |            17-03-07 12:30:00                     |     Hovgaard

The client will enter a start time and a end time and this query should then count how many records that are inside this periode of time.

 Example: The client enter starttime: 12:05 and endtime: 12:35.

The query shall then return 1 record found.

The same thing if the user enters 12:20 and 12:50.

My current query looks like this:
SELECT COUNT(ID) AS Expr1 FROM table WHERE (start_stamp <= @pausetime_start) AND (end_stamp >= @pausetime_end)

But this will only count if I enter the exact same times as the one inside the table.

Any ideas how I can figure this out?

Thanks for your time so far :)

/Jonas Hovgaard - Denmark