Problems with the Len function in SQL Server

LEN (' T ') =1

LEN (' T ') =2

Be aware of the decomposition of strings in the database, such as ' ^ ' separating ' X ^ t ', to be aware that the last ' t ' is broken down to ' t '

The following code can be used to complete the decomposition

SETAnsi_nulls onGOSETQuoted_identifier onGOCREATE function [dbo].[Fnsplitwithempty](@SourceStr varchar(8000),@StrSeprate varchar(Ten))returns @temp Table(IDint, strlistvarchar( +)) as begin    Declare @i int    --Set @SourceStr = RTrim (LTrim (@SourceStr))    Set @i = charindex(@StrSeprate,@SourceStr)    Declare @j int    Set @j = 0     while @i>=1    begin        Insert @temp Values(@j, Left(@SourceStr,@i-1))        Set @SourceStr = substring(@SourceStr,@i+1,Len(@SourceStr + 'x')- 1 -@i)        Set @i = charindex(@StrSeprate,@SourceStr)        Set @j = @j + 1    End    if @SourceStr <> "'       Insert @temp Values(@j,@SourceStr)    return End

Problems with the Len function in SQL Server