SQL Select statement

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

Well to the best of my knowledge (which is exceedingly limited) unless you use "select *" then you're gonna have to enter every field.