DECLARE @str NVARCHAR(MAX) = N'     Insus.NET           '
 
SELECT @str AS [str], [dbo].[svf_StringLength](@str) AS [length]
 
 
SELECT LTRIM(@str) AS [str], [dbo].[svf_StringLength](LTRIM(@str)) AS [length]
 
 
SELECT RTRIM(LTRIM(@str)) AS [str],[dbo].[svf_StringLength](RTRIM(LTRIM(@str)))AS [length]
 
 
SELECT TRIM(@str) AS [str], LEN(TRIM(@str)) AS [length]