Omnis Mysql defined list

[Graham Stevens]

Hi Phil,

Thank you.  They (whoever "they" are) say you should learn something new 
every day.
Didn't know that concat() ignores NULLs, I've always used coalesce() in 
functions where I suspect there might be NULLs.

Cheers,
Graham

On 16-12-2016 09:04, Phil (OmnisList) wrote:
> Hi Doug,
>
> Of course, no sooner than I ask, I find the answer online.
> Its a string concat() function, but like an Omnis calculation if there 
> is a null it returns null.
>
> I've always used a concat() function in these cases, never seen the 
> double lines in SQL?
>
> regards
> Phil Potter
> Based in Chester in the UK.
>
> On 16/12/2016 08:53, Phil (OmnisList) wrote:
>> Hi Doug,
>>
>> Not seen the double vertical lines before, what do they mean in this 
>> select?
>>
>> Is this a PostGreSQl thing only?
>>
>> regards
>> Phil Potter
>> Based in Chester in the UK.
>>