Re: Need Help with PL/SQL

atyagi_at_mc.xerox.com wrote:
>
> SELECT EO_SHIPPED.SHIP_DATE, EO_SHIPPED.ORDERNUM
> FROM EO_SHIPPED
> WHERE ((EO_SHIPPED.SHIP_DATE BETWEEN '14-SEP-96' AND '15-SEP-96')
> AND
> EO_SHIPPED.SHIP_DATE NOT IN
> (SELECT EO_SHIPPED.SHIP_DATE
> FROM EO_SHIPPED
> WHERE TO_CHAR(EO_SHIPPED.SHIP_DATE,'DAY')='SATURDAY'
> OR TO_CHAR(EO_SHIPPED.SHIP_DATE,'DAY')= 'SUNDAY'
> ));
>
> I tried running subquery seprately but it seems that it is
> not liking my comparision with Sat. & Sun and doesn't return
> me anything.

The DAY format returns 9-character names. Try comparing with 'SATURDAY ' and 'SUNDAY ' or using RTRIM() on the formatted value.

-- 
Eric Amick
Columbia, MD
eamick_at_clark.net