Hi, I've a table with some data...
CREATE table test (ID INTEGER PRIMARY KEY, a TEXT, b TEXT); INSERT INTO test (id, a, b) VALUES (1, "0356 bla bla bla", NULL);
I need to retrieve the string resulting from concatenating the a & b field...
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
So I tried using coalesce (and ifnull), but it converts the string to a integer...
SELECT colasce(a, '') | coalesce(b, '') WHERE ID=1;
-> 356
Any idea about howto can I get the proper value?
Thanks
Paolo
