Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version


Your embedded CONCAT is over the top. A Case When in the middle of the concat will work such as:

concat(Name, CHAR(10),
     Case When Addr2 IS NULL Then Concat(Addr1,CHAR(10), City)
               Concat(Addr1,CHAR(10),Addr2,CHAR(10),City) End ) As MyLabel

What is happening here is that you are doing separate concats with different data within the concat depending upon Address #2.

Tested in MySQL query & results on a form.