I'm trying to find a way to combine two columns into one, but keep getting the value '0' in the column instead to the combination of the words.
These are what I've tried as well as others:
SELECT column1 + column2 AS column3
FROM table;
SELECT column1 || column2 AS column3
FROM table;
SELECT column1 + ' ' + column2 AS column3
FROM table;
Could someone please let me know what I'm doing wrong?
See Question&Answers more detail:os