>There are many fields
>
>Is there other way rather than using select * ?
There are excellent intellisense scripts by Frank Dietrich - look up here in downloads - one of them is fieldlist. You just type that, it comes up with a list of ALL the fields for a given alias. You then just delete those you don't want.