Suppose I have database table *TABLE1* and there is Column *COLUMN1*. The variable declaration for that column is set up as `VARCHAR(20)`. Also, the column value can be `NULL` or `EMPTY`.

Suppose I have some 'dates' in that column (Format 12/01/2011) and I need a query to retrieve the dates, cannot be `NULL` or Empty and the dates are upto one year in the past (Suppose current date is 01/25/2012. I need the dates before 01/25/2011).

Please, help.