[EMAIL PROTECTED] wrote:
Paolo Vernazza <[EMAIL PROTECTED]> writes:
[...]
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?
The string concatenation token is "||" not "|". A single pipe character is a bit-wise OR operator.
Whoops! You are right :)
Paolo
