Topic: Calculated Field
In sqlite the calculated field works well, but not in MySql: ifnull(firstname,'')||' '||ifnull(lastname,''). How can I get it work in Mysql?
My Visual Database → General → Calculated Field
In sqlite the calculated field works well, but not in MySql: ifnull(firstname,'')||' '||ifnull(lastname,''). How can I get it work in Mysql?
Hi Kees,
Try it as
concat(expression1,"literal2 ", expression3) and so on.
I think that should work (but I dont use MySQL so can't check it).
Derek.
you can also try
CONCAT(COALESCE(firstname,''),' ',COALESCE(lastname,''))
But you can also use and retain function IFNULL instead of COALESCE as Derek's Code. It'll work just fine too.
My Visual Database → General → Calculated Field
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi