How will i write SQL statement which will go through the table and show me list of records and if there is record with smilar value then compare the date and show only newer record . <BR><BR>Thanks <BR>Farhan