UFN_NETCOMMUNITYDEFAULTCODEMAP_GETCHANNELCODE

CREATE function dbo.UFN_NETCOMMUNITYDEFAULTCODEMAP_GETCHANNELCODE()
returns uniqueidentifier
with execute as caller
as begin
    -- do work here and return a value

  declare @CHANNELCODEID uniqueidentifier;

  select top 1 @CHANNELCODEID = CHANNELCODEID from NETCOMMUNITYDEFAULTCODEMAP(nolock);

  return @CHANNELCODEID;
end