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

>Hi Helen
>
>I did know that much but I was wondering if I could something like
>
>Select * except feild1 from MyTable......
>
>
>Because I have a table that has 48 fields, and I would like to select
>them all except 1 field.
>
>Its not a big deal, but I was just wondering.

Nope. Heck, "Select * " is **bad enough** !!!

Did you know that IB_SQL has a nifty little helper in the Browse tool,
which lists all of the columns of a table in "copy-paste" format, so that
you can just lift them out and drop them straight into your query string?

If you have IB_SQL, open the Browse tool and select your table. Then click
the "Field Names List" tab at the right, then the "Comma and Space" radio
button - and there is your ready-to-go fieldlist.

You can can IB_SQL free from www.ibobjects.com

heLen