UFN_PHONE_REMOVECOUNTRYCODE

create function dbo.UFN_PHONE_REMOVECOUNTRYCODE(@NUMBER nvarchar(100), @COUNTRYID uniqueidentifier)
returns nvarchar(100)
with execute as caller
as begin

    if @COUNTRYID is null begin
        return @NUMBER;
    end

    declare @COUNTRYCODE nvarchar(10);
    select
        @COUNTRYCODE = '+' + [COUNTRY].[COUNTRYCODE]
    from
        dbo.[COUNTRY]
    where
        [COUNTRY].[ID] = @COUNTRYID

    if left(@NUMBER, len(@COUNTRYCODE)) = @COUNTRYCODE begin
        set @NUMBER = ltrim(right(@NUMBER, len(@NUMBER) - len(@COUNTRYCODE)));
    end

    return @NUMBER;

end