MIGRATE SYN_CHARACTER_SORT function for HANA

ADMM Construct comes with a TSQL function, CONSTRUCT.dbo.

SYN_CHARACTER_SORT. An equivalent function should be available in the MIGRATE database when using HANA for the working databases. See below for a working definition.

CREATE FUNCTION "MIGRATE"."SYN_CHARACTER_SORT" (IN STRING NVARCHAR(1000))
RETURNS WORD NVARCHAR(1000)
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER
AS
BEGIN
      DECLARE STR NVARCHAR(1000) := LTRIM(:STRING);
 
      SELECT STRING_AGG(SUBSTRING(:STR, N.ELEMENT_NUMBER, 1),'' ORDER BY SUBSTRING(:STR, N.ELEMENT_NUMBER, 1)) INTO WORD
      FROM SERIES_GENERATE_INTEGER(1, 1, LENGTH(:STR)+1) N;
       
END;