[thelist] Using Wildcards and Dates in SQL Server

[Joe Lance]

try
 where datediff(month, edate, getdate()) = 0

hth,
joe

-----Original Message-----
From: Ken Kogler [mailto:ken.kogler at curf.edu]
Sent: Tuesday, June 17, 2003 9:25 AM
To: thelist at lists.evolt.org
Subject: [thelist] Using Wildcards and Dates in SQL Server


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

-- 
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

Evolt.org conference in London, July 25-27 2003.  Register today at
http://evolt.org.uk

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt !