Thanks for all the help, guys. I'm back up, but a lot of my cool tricks are gone. Gotta get a better backup plan... Gerry On 3/12/06, Gerry Danen <gdanen@xxxxxxxxx> wrote: > > While I am rebuilding my crashed laptop (the machine that had all my > intelligence), I started thinking about a select statement I need. > > I have log info in a table and want to extract it on a monthly basis. The > date field is in yyyy-mm-dd format. What's a good way to select those dates > that match 2006-02, for example. > > I apologize if the solution should be staring me in the face, but all my > favorites and help files are toast, until I can restore some of them. > > TIA. > > Gerry > > -- Gerry http://portal.danen.org/