Hi,
I'm trying to concatenate two columns with space in between. No matter what I do I get this error:
[nQSError: 22020] Function Concat does not support non-text types.
However, if I concatenate these two columns without space it works!
I've tried a lot of options.
So, for a concrete example:
concat(CountryName, CountryId) - works, gives result: England1000
CountryName||CountryId - works, gives result: England1000
concat(concat(CountryName,' '), CountryId) - nQSError: 22020
concat(concat(cast(CountryName as varchar),' '), cast(CountryId as varchar)) - nQSError: 22020
CountryName||' '||CountryId - nQSError: 22020
cast(CountryName as varchar)||' '||cast(CountryId as varchar) - nQSError: 22020
Even if I try to join just one column (CountryName) with a custom text it does not work, for example:
CountryName||' ' - nQSError: 22020
CountryName||'-' - nQSError: 22020
concat(CountryName,' ') - nQSError: 22020
concat(CountryName,'-') - nQSError: 22020
concat(CountryName,'TEST') - nQSError: 22020
I even tried with IFNULL if nulls were causing a problem but that still didn't help.
concat(IFNULL(CountryName,''),'-') - nQSError: 22020
I tried casting as char too.
How do I solve this? It seems I've run out of options to try...
Thanks in advance