如何在SQL Server中重写这些TRIM Access查询

I am rewriting more code from Access to SQL Server and I have never encountered a TRIM code before, any ideas how to write it for SQL Server as far as I know there is not just plain TRIM for SQL ServerI am rewriting more code from Access to SQL Ser