• So it would have to be something like:

    select ProdMonth ,ProdYear from Production

    where ProdYear >= cast(datepart(yyyy,DATEADD(yyyy,-1,getdate())) as int)

    I second Jeff's suggestion to store dates as dates.


    And then again, I might be wrong ...
    David Webb