Dont know about mssql but in mysql there is a function like dayofweek

So select becomes

Select xxxxxx from abcd where x=y and y=z and dayofweek(datecolumn) not in (6,7)

From: Calvin Omari [mailto:calvinebarongo@gmail.com]
Sent: 16 August 2010 1:58 p
To: Skunkworks Forum
Subject: [Skunkworks] MSSQL - getting time different excluding weekends

Hi,
I am doing an ms sql select but i want to exclude week ends as i want am doing a different bewteen when a product was sold and when payment was done I need the diffrent between the sold date and paid date excluding weekends

Any idea is highly appreciated

Regards
--
Our greatest fear is not that we are inadequate,
but that we are powerful beyond measure.
It is our light, not our darkness, that frightens us.

Calvin Omari Systems Developer/Designer
http://www.facebook.com/barongo