I have two string columns a
and b
in a table foo
.
select a, b from foo
returns values a
and b
. However, concatenation of a
and b
does not work. I tried :
select a || b from foo
and
select a||', '||b from foo
Update from comments: both columns are type character(2)
.