Closed GoogleCodeExporter closed 9 years ago
Hi,
The 'standard' way to concatenate text within SQL is to use ||. Most databases
(except Microsoft SQL Server) don't support + for text. H2 does support it,
however
only when using the MS SQL Server compatibility mode:
http://h2database.com/html/features.html#compatibility
To use it, append ;MODE=MSSQLServer to the database URL. Example URL:
jdbc:h2:~/test;MODE=MSSQLServer
See also: http://h2database.com/html/grammar.html#operand
Regards,
Thomas
Original comment by thomas.t...@gmail.com
on 18 May 2010 at 6:23
Original issue reported on code.google.com by
jack...@gmail.com
on 17 May 2010 at 4:17