[thelist] Using Wildcards and Dates in SQL Server
Ken Kogler
ken.kogler at curf.edu
Tue Jun 17 11:25:06 CDT 2003
Why doesn't this return anything? (SQL Server 2000, IIS5, Win2K)
SELECT * FROM curEvents WHERE eDate LIKE '6/%/2003'
I thought the % character worked as a wildcard -- am I missing
something?
There's got to be a million ways to get the current month's events out
of this table. Anyone want to suggest a better one?
Thanks in advance, folks!
--ken
More information about the thelist
mailing list