Hi,

Using Date_Col = '08-Nov-00' will also include Time part, HH:MI:SS in the Date_Col, at the time of comparision. So try out truncating the column. Try : TRUNC(Date_Col) = '08-Nov-00' and do check the NLS Date formate for your database.

Hope this works,

Pinakin.