You are here: Home > Technical Articles > MS SQL Server - Script for function get substring

MS Sql Server - Script for function get substring

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'f_get_substring' AND type = 'FN')
BEGIN
    DROP FUNCTION f_get_substring
END
GO

CREATE FUNCTION dbo.f_get_substring(
        @string                varchar(1000),
        @length                int,
        @trailing_string    varchar(100)
) RETURNS varchar(1100)

BEGIN
    DECLARE @str    varchar(1100)

    SET @str = @string

    IF LEN(@string) > @length
    BEGIN
        SET @str = SUBSTRING(@string, 0, @length) + @trailing_string
    END

    RETURN @str
END
GO

GRANT EXECUTE ON f_get_substring TO Public
GO


Published On: 02 Aug 2009