in my table i have fields from and to date that i want to compute, so using SQL i use,

SELECT empno,(todate-frdate) as "mydate" from mytable

say todate=10/06/2003 and frdate=10/01/2003..

how do i compute the date so that i would give me a value excluding saturday and sunday?

IIF(dow(todate-frdate)!=6 or dow(todate-frdate)!=7) in SQL does not work.

any help pls?