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.