Hi Gert, >>I found that it is possible, see quotes below. What I can't find (and I >>promise I have googled, KBed and Manualed it to death), is what the correct >>syntax is, either in SQL View or Design View, i.e. how do I present the >>FIELD1 * FIELD2 (like in Access it was [FIELD1] * [FIELD2]). Any suggestions >>where to start looking? (Of course I don't know the version numbers, but >>they mention that in the latest version the "have improved it", so in some >>form it must have been there for a while.
What's wrong with SELECT "FIELD1" * "FIELD2" FROM "TABLE"? Works perfectly for me. If this is not what you need, please elaborate. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
