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@[...].com>  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/