The 'Datepart' function has an option to return the day of the week - is
that what you are looking for?

e.g.

	Datepart(dw,Getdate())

will return the day of the week that today is...

--
Jeff Mason			Custom Apps, Inc.
Jeff@c...

-----Original Message-----
From: herbe@a... [mailto:herbe@a...]
Sent: Monday, July 29, 2002 12:48 PM
To: sql language
Subject: [sql_language] Weekday Function


Is there a way in sql to use the Weekday Function or something close to it?


Thanks