hello, is there any chance to select all column from table except one without naming what all i want select. something like that: select * from table_1 except NAME ??? thanks for help Peci
No.
I think what you are getting at is really a != in the WHERE clause...
i.e.
select * from table where name != ???;
se?
Stephen