At 07:07 AM 1/09/2003 +0000, you wrote:

>Hi
>
>Can I in a select statement select evrything but 1 field ?

Yes. Use a column list and just omit the one(s) you don't want:

select Col1, Col2, .... LastCol
from aTable
where...

heLen