SELECT all records from current month query

[jasonsalas]

I've been trying to grab all records from the current month, but I've run into trouble. This is what I'm using:

SELECT ColumnID,ColumnDate FROM TableName WHERE ColumnDate = MONTH(GETDATE())

Got any pointers on how to evaluate a column of type SMALLDATETIME, only looking within the current month?

Thanks!

 

[jasonsalas]

<GROAN!>

In lieu of more accurate testing, I think this works (figured it out in .002 seconds after my post):

SELECT ColumnID,ColumnDate FROM TableName WHERE MONTH(ColumnDate) = MONTH(GETDATE())