title: call an SQL User Defined Function Within another User Defined Function
body: <p>I have the following UDF which i want to call another udf that split the result on return </p>
  
  <pre><code>-- =============================================
  CREATE FUNCTION [dbo].[ufnGetValueForEmployeeTable]
  (   
      @EeID       AS int,
      @ProvisionID    AS int,
      @optionName     AS varchar(4000)
  )
  RETURNS varchar(128)
  AS
  BEGIN
      SELECT 
      WHERE  
      RETURN **call here this function** GetOptionValueFromOtherOptions(@optionName ,  @value `this is the value from select` )
  </code></pre>
  
  <p>Is it possible ? if yes how?</p>