year from date field
in cdhdr table udate field is there. i want to retrieve the records belong to 2007
only. when i am using offset on udate field as udate+0(4) in the select statement it is showing error. plz tell me how to retrieve only year form udate field in select stament.