====== 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>
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."SocialMediaResolve" IS 
{create function 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>