[Solved] CONCAT in stored procedure returns null

by


The documentation says

CONCAT() returns NULL if any argument is NULL.

This is demonstrated by this example: http://sqlfiddle.com/#!2/d41d8/47037

You can find some documentation on working with nulls here: http://dev.mysql.com/doc/refman/5.0/en/working-with-null.html

2

solved CONCAT in stored procedure returns null