Many Thanks On Oct 1, 7:02 am, Thomas Mueller <[email protected]> wrote: > Hi > > 1) You need to use || instead of &: > > SELECT SURNAME || ' ' || FORENAME AS FULLNAME FROM EMPLOYEE_DATA > > I didn't know & can be used to concatenate text in MS Access. I will > add a feature request. > > 2) Alias column names: > Seehttp://h2database.com/html/faq.html#column_names_incorrect: "If you > need compatibility with those databases, use the Compatibility Mode, > or set the system property h2.aliasColumnName." > > To set a system property, see the top of the > page:http://h2database.com/javadoc/org/h2/constant/SysProperties.html > > Regards, > Thomas
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
