title: How to create user defined function using variable in snowflake?
body: <p>I am trying to create a UDF to get full_name in snowflake with the below code:</p>
  <pre><code>CREATE OR REPLACE FUNCTION LASTNAMEFIRST (LAST_NAME char(100),FIRST_NAME char(100))
     
  RETURNS CHAR(1000)
     AS
  'declare
   FULL_NAME varchar;
   begin
   FULL_NAME := FIRST_NAME || '' '' || LAST_NAME;
   return FULL_NAME;
   End';
  </code></pre>
  <p><em>I am getting Compilation of SQL UDF failed: SQL compilation error: syntax error line 2 at position 1 unexpected 'FULL_NAME'. error</em></p>
  <p>Your help would be appreciated.</p>