How do I search DateTime Data in MS SQL 2005?

I am trying to create search page in ASP classic.

How do I create a query that will select similar date?
For Example, when I use this query " Select * from Board where RegisterDate ='2007-11-28' " it gave me a blank result because I didn't input the time.
So I used "Like" query, and it still gives me a blank result.
Select * from Board where RegisterDate Like '%2007-11-28%' "

How do I select the date without inputing time?

Thank you
erin027Asked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
Select * from Board where RegisterDate >='2007-11-28'  and RegisterDate <'2007-11-29'   ---- original date +1
0
All Courses

From novice to tech pro — start learning today.