TRIM and then Left would work if you are using SQL Server 2017 or above, since, SQL Server TRIM works the same as LTRIM and RTRIM combined, as shown...