SQL : Counting the no: of fridays between two dates

Hai every body,

My issue is that i have a startdate and enddate. Using a query I need to find the total No: of fridays(or any day) between those dates.

Using SQL is it possible to do that?


PLease help

Regards
Issac

select (next_day('26-oct-2005', 'FRI') - next_day('03-oct-2005', 'FRI'))/7 from dual

Scorby....
That was just superb

THanks a lot...

Regards
Issac