I tried using the | operator, but it seems that concatenating a string and a NULL results in a NULL value..
SELECT a | b FROM test WHERE ID=1;
-> NULL
The operator for concat is ||, | is for bitwise operation, isn't it?
So I tried using coalesce (and ifnull), but it converts the string to a integer...
SELECT colasce(a, '') | coalesce(b, '') WHERE ID=1;
-> 356
Try:
SELECT colaesce(a, '')||coalesce(b, '') WHERE ID = 1;
Marcel
