This is a multi-part message in MIME format.

------=_NextPart_000_002F_01C1AAC8.2B1F0980
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thanks Eva!!!!! :)

Enzo :)
  ----- Original Message -----
  From: Zadoyen, Eva
  To: sql language
  Sent: Thursday, January 31, 2002 10:37 PM
  Subject: [sql_language] RE: Filter by Month


  Enzo,
  You can do something like:

  SELECT DISTINCT  TranDate FROM MyTable WHERE MONTH(TranDate)=3D1

  Good luck!
      Eva
  -----Original Message-----
  From: Zaragoza, Enzo [mailto:enzaux@g...]
  Sent: Thursday, January 31, 2002 9:31 AM
  To: sql language
  Subject: [sql_language] Filter by Month


  I have this Field called TranDate and it contains Dates like 
1/25/2002.  Now what I want is Select all dates for January only?  Any 
idea?

  Thanks,

  Enzo :)
$subst('Email.Unsub'). ---
$subst('Email.Unsub').