Omnis Mysql defined list

Graham Stevens graham.stevens at
Fri Dec 16 04:46:18 EST 2016

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.


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.

More information about the omnisdev-en mailing list