August 7th, 2003, 08:58 AM
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
August 12th, 2003, 07:58 PM
Well to the best of my knowledge (which is exceedingly limited) unless you use "select *" then you're gonna have to enter every field.