16

Good day!

What is the equivalent function of Derby/Java DB to the CONCAT function of MySQL?
I tried using CONCAT to Derby but it commits an error.

Ace Eusebio
  • 403
  • 1
  • 7
  • 17

1 Answers1

21

I believe you can concatenate two string with ||

Derby Built-in function reference - concatenation

Rangi Lin
  • 9,303
  • 6
  • 45
  • 71
  • No problems. If you think this answer helps, you can accept this answer. [How do I ask questions here?](http://stackoverflow.com/faq#howtoask) – Rangi Lin Apr 18 '12 at 06:36
  • 3
    `||` is the ANSI standard for string concatenation and will work with nearly all DBMS except MySQL and Microsoft –  Apr 18 '12 at 06:38