pears.SocialMediaResolve

CREATE FUNCTION "pears"."SocialMediaResolve"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "MediaName" CHAR(2),IN "Number" CHAR(100) ) 
RETURNS CHAR(100)
BEGIN
  /* MediaName LI - LinkedIn TW - Twitter SK - Skype FB - Facebook */
  CASE "MediaName"
  WHEN 'TW' THEN
    CASE
    WHEN "Number" LIKE 'https:%' THEN RETURN "Number"
    WHEN "Number" LIKE 'www.twitter%' THEN RETURN "string"('https://',"Number") ELSE
      RETURN "string"('https://www.twitter.com/',"Number")
    END CASE
  WHEN 'SK' THEN
    IF "Number" LIKE 'skype://%' THEN RETURN "string"("Number",'?call')
    ELSE RETURN "string"('skype://',"Number",'?call')
    END IF WHEN 'FB' THEN
    CASE
    WHEN "Number" LIKE 'http:%' THEN RETURN "Number"
    WHEN "Number" LIKE 'www.facebook%' THEN RETURN "string"('http://',"Number") ELSE
      RETURN "string"('http://www.facebook.com/',"Number")
    END CASE
  WHEN 'LI' THEN
    CASE
    WHEN "Number" LIKE 'http:%' THEN RETURN "Number"
    WHEN "Number" LIKE 'https:%' THEN RETURN "Number"
    WHEN "Number" LIKE 'uk.linkedin%' THEN RETURN "string"('http://',"Number")
    WHEN "Number" LIKE 'www.linkedin%' THEN RETURN "string"('http://',"Number")
    WHEN "Number" LIKE '%/%' THEN RETURN "string"('http://uk.linkedin.com/pub/',"Number") ELSE
      RETURN "string"('http://uk.linkedin.com/in/',"Number")
    END CASE ELSE
    RETURN "Number"
  END CASE
END