Concatenating Strings

  • Comments posted to this topic are about the item Concatenating Strings

  • As an aside, the symbol for concatenation in ANSI/ISO standard SQL is <string 1> || <string 2>. ANSI X3 H2. picked this symbol from the old PL/1 programming language. It could be written as either two vertical bars, or as the single "double pipe" in Unicode.

    Please post DDL and follow ANSI/ISO standards when asking for help. 

  • Yes, I also used || in Oracle.

    That goes way back to the early 1990s.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply