Scalar-valued Functions [dbo].[truncate_left]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@strnvarchar1
@nint4
SQL Script
CREATE FUNCTION truncate_left (@str NVARCHAR, @n INT)
   RETURNS NVARCHAR
   AS
   BEGIN
    RETURN SUBSTRING(@str, @n+1, LEN(@str));
   END;
GO
Uses