TRIM SQL function

1. Usage of TRIM to clean company name, contact name and address.

SQL Server Query 1

            
SELECT top 10  

	CustomerID,  

	TRIM(CompanyName) AS CleanedCompanyName,  

	TRIM(ContactName) AS CleanedContactName,  

	TRIM(Address) + ', ' + TRIM(City) + ', ' + TRIM(PostalCode) AS CleanedAddress  

FROM Customers;  

            
        

Create SQL query with SqlQueryBuilder 1

            
var (sql1, parameters1) = new SqlQueryBuilder()  

    .Select().Top(10)  

    .Column("CustomerID", "CustomerID")  

    .Column(new TRIM(new Column("CompanyName")), "CleanedCompanyName")  

    .Column(new TRIM(new Column("ContactName")), "CleanedContactName")  

    .Column(new CONCAT(new TRIM(new Column("Address")), ", ", new TRIM(new Column("City")), ", ", new TRIM(new Column("PostalCode"))), "CleanedAddress")  

    .From("Customers")  

    .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT TOP 10 CustomerID AS CustomerID,
              TRIM(CompanyName) AS CleanedCompanyName,
              TRIM(ContactName) AS CleanedContactName,
              CONCAT(TRIM(Address), @pMAIN_2507192016471662500, TRIM(City), @pMAIN_2507192016471662501, TRIM(PostalCode)) AS CleanedAddress
FROM Customers;


            
        

Parameters (If used)

Query Results 1: