Disclosed Information

I didn’t find an answer to this in my first few google search results, so I’m posting it here.
When using CONCAT() in MySQL, if any of the values are NULL, then the CONCAT fails and the return is NULL. BQW told me about NVL(), which is Oracle/PGSQL (so useless for me), but that led [...]

Posted on July 25th, 2008 under programming, work. Comments: None