select cont_date, cust_name, cust_addr from yourtable ;
where cont_date = gomonth(date(),-6)

>hi all,
>
>i need to select cont_date, customers names ,customers adress...etc
>
>befor six month .
>
>if date is 01/07/2007
>cont_date cust_name cust_addr
>01/01/2007 aaaa ........
>.
>.
>************************************
>if date is 02/07/2007
>cont_date cust_name cust_addr
>02/01/2007 bbbb ......... .
>.
>.
>
>thanks