I want to select all fields from my SQL table apart from one. Does anybody know of a way i can select all fields apart from one, or two, or three?

Or do you have to enter a full select statement as in select field1, field2, field3, field4 etc etc from tbltable.

I have about 40 fields in a table and just want to select certain ones without making a view.

Thanks for you help in advanced