Display all the fileld except one field.

[kingganesh04]

i need the sql query and progress coding for

display all the field except one filed.

Ex:

table name emp
fields :e-no,e_name,e_ad1,e_ad2,e_ph ,etc


Select * , with out e_ad2 from emp;

 

[taqvia]

In Progress You can use the except command


FOR EACH state NO-LOCK:
DISP state EXCEPT region WITH 2 COL ./* it will dis all fields in table state except region */
END.


Regards,

Arshad