Hi Jamie,

Thank you for reply. I will try giving a CASE Statement a
try.

Dave Y
-----Original Message-----
"Dave Y" wrote ...

script that I run returns the previous days information
from the DB using a SYSDATE -1 statement.
As it stands now, I manually edit
the SQL script to bring back the information from
Saturday.

I don't have Oracle to check how its proprietary
functions work but
could you perhaps test for Monday using:

to_char(sysdate,'DDD')

in a CASE (or equivalent) statement?

Jamie.

--
.