title: how to cast in MySQL stored procedures
body: <p>Trying to create the following routine in MySQL Workbench yields a "This object's DDL statement contains syntax errors. Are you sure you want to apply the DDL statement unchanged?":</p>
  
  <pre><code>-- --------------------------------------------------------------------------------
  -- Routine DDL
  -- Note: comments before and after the routine body will not be stored by the server
  -- --------------------------------------------------------------------------------
  DELIMITER $$
  
  CREATE PROCEDURE `dbName`.`testFunc` ()
  BEGIN
  SET i = CAST(100 AS DOUBLE);
  END
  </code></pre>
  
  <p>Any ideas?</p>
  
  <p>This does the same thing:</p>
  
  <pre><code>-- --------------------------------------------------------------------------------
  -- Routine DDL
  -- Note: comments before and after the routine body will not be stored by the server
  -- --------------------------------------------------------------------------------
  DELIMITER $$
  
  CREATE PROCEDURE `rateGenius`.`testFunc` ()
  BEGIN
  
  SET i = CONVERT(100, DOUBLE);
  END
  </code></pre>