[dbo].[truncate

[dbo].[truncate_right]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@str	nvarchar	1
@n	int	4

CREATE FUNCTION truncate_right(@str NVARCHAR, @n INT)
RETURNS NVARCHAR
AS
BEGIN
RETURN SUBSTRING(@str, 1, LEN(@str)-@n);
END;
GO