====== pears.SocialMediaResolve ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
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
</code>