is there a way to select all columns from a table except one of them?
Not without naming all of them (except one) in your select statement..............
ok