title: Error Code: 1292. Truncated incorrect INTEGER value: ''
body: <p>I did a trigger validating two columns,when only one of them is wrong it show the message normally,when both are wrong I get the error </p>
  
  <blockquote>
    <p>Error Code: 1292. Truncated incorrect INTEGER value: ''      </p>
  </blockquote>
  
  <p>I believe it's on the Concat part am I missing something on the function?</p>
  
  <pre><code> if(RESULTADO = false) then
      set msg = "Cpf invalido";
   end if;
  
      if(new.idadeproprietario &lt;18) then
  
          set msg2 = "Idade invalida";
      end if;
  
      if (msg is not null) or (msg2 is not null) then 
  
              select Concat(msg, msg2) into msg3;
  
          Signal sqlstate '40000' set message_text = msg3;
      end if;
  </code></pre>