[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

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!


More information about the thelist mailing list