how to 'tell' the select what to omit

[Miroslav I.]

------=_NextPart_000_ 0009_01C35A6F.9 908B420
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

Hallo

suppose you have a table with great number of columns (20 or 30),
and you would like to specify every one but two or tree columns in a =
SELECT statement.

Is there a way to specify only those two or tree columns for omission =
(which would be the 'short' way to do the job) instead of specifying =
every column that needed (which would be the 'long' way to do the job).

Example:

The 'TName' table header:

id | name | surname | dateOB | idSCHOOL | idCITY | idSTATE | sex | =
idParent1 | idParent2 | interests | weight | height | age | auditDate | =
idAudittor | ....

You need every field except the 'dateOB' and 'idSCHOOL'

Ordinary select wold be:

SELECT =
id,name,surname ,idCITY,idSTATE ,sex,idParent1, idParent2,inter ests,weight,h=
eight,age,audit Date,idAudittor , ....
FROM TName

It is too long expression,=20
is there a way to specify only 'dateOB' and 'idSCHOOL' - the two column =
that are unwanted in the result set - in order to make the SELECT =
shorter? The SELECT should return every column but the specified ones.
------=_NextPart_000_ 0009_01C35A6F.9 908B420--