Concatenating Strings

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737630

  More actions

  August 21, 2024 at 12:00 am

  #4446599

  Comments posted to this topic are about the item Concatenating Strings

• jcelko212 32090

  SSCrazy Eights

  Points: 9304

  More actions

  August 23, 2024 at 2:14 pm

  #4448670

  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. 

• paul s-306273

  SSChampion

  Points: 10730

  More actions

  August 23, 2024 at 3:11 pm

  #4448682

  Yes, I also used || in Oracle.

  That goes way back to the early 1990s.