Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
mikejohnson
Posting Yak Master
153 Posts |
Posted - 2003-01-03 : 14:45:44
|
I'm trying to search through a table where the user enters the date for a datetime field. What syntax should I be using? Using "select * ... like '%5/23/1999%'" doesn't work.. |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-03 : 15:06:59
|
You will need to use the DATEPART function. |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-01-03 : 16:13:33
|
= '5/23/1999' |
|
|
|
|
|