Ken Kogler <mailto:ken.kogler at curf.edu> wrote: > 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? Because there are no dates that match "6/%/2003". I've only seen %'s used like this: SELECT id, name FROM products WHERE description LIKE %horse radish% I don't think it works when it's embedded in a string literal (single quotes) as you have it. > 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? You should build your sql statement dynamically using the month() function of vbscript. Chris.