CREATE FUNCTION GETIP(INITVALUE VARCHAR(128)) RETURNS VARCHAR(20)
   LANGUAGE SQL 
   CONTAINS SQL
BEGIN ATOMIC
   DECLARE vFIRST VARCHAR(10);
   DECLARE vSECOND VARCHAR(10);
   DECLARE vTHIRD VARCHAR(10);
   DECLARE vFOURS VARCHAR(10);
   DECLARE TMP VARCHAR(128);
   
   IF LOCATE('*LOCAL',INITVALUE) > 0 THEN
      RETURN '127.0.0.1';
   ELSE
      SET vFIRST = SUBSTR(INITVALUE,1,POSSTR(INITVALUE,'.'));
      SET TMP = SUBSTR(INITVALUE,LENGTH(vFIRST)+1, LENGTH(RTRIM(LTRIM(INITVALUE))));
      
      SET vSECOND = SUBSTR(TMP,1,POSSTR(TMP,'.'));
      SET TMP = SUBSTR(TMP,LENGTH(vSECOND)+1, LENGTH(RTRIM(LTRIM(TMP))));
      
      SET vTHIRD = SUBSTR(TMP,1,POSSTR(TMP,'.'));
      SET TMP = SUBSTR(TMP,LENGTH(vTHIRD)+1, LENGTH(RTRIM(LTRIM(TMP))));
      
      SET vFOURS = SUBSTR(TMP,1,POSSTR(TMP,'.')-1);/**/
      RETURN /**/vFIRST||vSECOND||vTHIRD||vFOURS/**/;
   END IF;   
END