CREATE FUNCTION dbo.GET_LAST_ATTRIBUTE
(
   @var_input_string nvarchar(max)
)
RETURNS nvarchar(max)
AS
   
   /*
   *   Generated by SQL Server Migration Assistant for Oracle.
   *   Contact ora2sql@microsoft.com or visit http://www.microsoft.com/sql/migration for more information.
   */
   BEGIN

      DECLARE
         @var_output_string nvarchar(255),
         /*
         *   SSMA warning messages:
         *   O2SS0356: Conversion from NUMBER datatype can cause data loss.
         */

         @var_dot float(53)

      IF @var_input_string NOT LIKE '%.%'
         SELECT @var_output_string = @var_input_string

      IF @var_input_string LIKE '%.%'
         BEGIN

            SELECT @var_dot = dbo.instr3_nvarchar(@var_input_string, '.', 1)

            /*
            *   SSMA warning messages:
            *   O2SS0273: Oracle SUBSTR function and SQL Server substring function may give different results.
            */

            SELECT @var_output_string = substring(@var_input_string, CAST(@var_dot + 1 AS int), 255)

            IF @var_output_string LIKE '%.%'
               SELECT @var_output_string = dbo.GET_LAST_ATTRIBUTE(@var_output_string)

         END

      RETURN @var_output_string

   END
GO