I would like to search dates in my SQL Server database. My WHERE clause looks like this:
Where DayRequested like '%" & Request.Form("MyDay") & "%'
The date I'm searching for is in the database, but my query still won't return any results.
The date is 'datetime' in my database. Would you please let me know what's wrong with my query?
Thank you very much...