How to use UPPER in a view ??? (Scalar Character Functions)

Hey SQL Gurus !

[Quoted] [Quoted] The select statement works. When I try to do it in a view like below,

[Quoted] CREATE VIEW stencil_p as

[Quoted]         select UPPER (slot_num), UPPER (apn_pb_num), UPPER
(apn_pba_num), UPPER (pb_alias_num), UPPER (pba_alias_num), UPPER
(dsr), thickness, UPPER (work_holder)

        from ssd.stencil
        where requirements ='P'
        and   status = 'R'         

I get the following error:

select UPPER (slot_num), UPPER (apn_pb_num) ........

        *
ORA-00998: must name this expression with a column alias

What does it mean ??? Thanks for taking the time to read it !!

[Quoted] PS: Is there a way to implement a case restriction in a combobox ?

Thanks
Jens
jens_at_deutschware.com Received on Wed Mar 26 1997 - 00:00:00 CET