Query a date field for a particular month 2

[mman74]

I have a table with a date field. The format is "01-Jan-03". How can I query the table for a particular month, say all January records?
Is it difficult? Do I need to create a dummy field equal to the date field but in string format? If so how do I do that? I can tell the user to input two date ranges but it seems rather long-winded.
Thank you.

 

[GHolden]

Something like this...

SELECT *
FROM tblDate
WHERE DATEPART('m',tblDate.fldDate) = 3;

Selects all records for month = 3 (March)

There are two ways to write error-free programs; only the third one works.

 

[flaviooooo]

something like
select * from <tblname> where datepart('m',<tblname>.<datefield>) = n
where n is the month number should do the trick

 

[mman74]

Thank you very much, flavioooo & GHolden! Works exactly as you said it would.