[Solved] CONCAT in stored procedure returns null

by

[ad_1]

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

[ad_2]

solved CONCAT in stored procedure returns null