Other LTRIM SQL function

1. Usage of LTRIM to find products starting with some text

SQL Server Query 1

            
 SELECT  

     ProductID,  

     ProductName  

 FROM  

     Products  

 WHERE  

     LTRIM(ProductName) LIKE 'Chef Anton%';  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Columns("ProductID", "ProductName")  

     .From("Products")  

     .Where(new Where(new LIKE(new LTRIM(new Column("ProductName")), "Chef Anton%")))  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT ProductID,
       ProductName
FROM Products
WHERE LTRIM(ProductName) LIKE @pMAIN_2507192101282697910;


            
        

Parameters (If used)

Query Results 1:

2. Usage of LTRIM to trim text

SQL Server Query 2

            
 SELECT TOP 20  

   CustomerID,  

   CompanyName,  

   LTRIM(CompanyName) AS TrimmedCompanyName  

FROM  

   Customers;  

            
        

Create SQL query with SqlQueryBuilder 2

            
 var (sql2, parameters2) = new SqlQueryBuilder()  

     .Select().Top(20)  

     .Columns("CustomerID", "CompanyName")  

     .Column(new LTRIM(new Column("CompanyName")), "TrimmedCompanyName")  

     .From("Customers")  

     .Build();  

            
        

Query build by SqlQueryBuilder 2

            
SELECT TOP 20 CustomerID,
              CompanyName,
              LTRIM(CompanyName) AS TrimmedCompanyName
FROM Customers;


            
        

Parameters (If used)

Query Results 2:

3. Usage of LTRIM in WHERE clause

SQL Server Query 3

            
 SELECT DISTINCT  

     s.SupplierID,  

     s.CompanyName,  

     e.Title AS RoleInAreaOfSupplier  

 FROM  

     Suppliers s  

 INNER JOIN  

     Employees e ON LTRIM(s.Country) = LTRIM(e.Country);  

            
        

Create SQL query with SqlQueryBuilder 3

            
 var (sql3, parameters3) = new SqlQueryBuilder()  

     .Select().Distinct()  

     .Columns("s.SupplierID", "s.CompanyName")  

     .Column("e.Title", "RoleInAreaOfSupplier")  

     .From("Suppliers", "s")  

     .Join(new List<IJoin>()  

     {  

         new INNERJOIN().TableName(new Table("Employees", "e"))  

             .On(new LTRIM(new Column("s.Country")).Equale(new LTRIM(new Column("e.Country"))))  

     })  

     .Build();  

            
        

Query build by SqlQueryBuilder 3

            
SELECT DISTINCT s.SupplierID,
                s.CompanyName,
                e.Title AS RoleInAreaOfSupplier
FROM Suppliers AS s
     INNER JOIN
     Employees AS e
     ON LTRIM(s.Country) = LTRIM(e.Country);


            
        

Parameters (If used)

Query Results 3:

4. Usage of LTRIM to search company name starting with specfic text

SQL Server Query 4

            
 SELECT  

     CustomerID,  

     CompanyName  

 FROM  

     Customers  

 WHERE  

     UPPER(LTRIM(CompanyName)) LIKE 'ALF%';  

            
        

Create SQL query with SqlQueryBuilder 4

            
 var (sql4, parameters4) = new SqlQueryBuilder()  

     .Select()  

     .Columns("CustomerID", "CompanyName")  

     .From("Customers")  

     .Where(new Where(new LIKE(new UPPER(new LTRIM(new Column("CompanyName"))), "ALF%")))  

     .Build();  

            
        

Query build by SqlQueryBuilder 4

            
SELECT CustomerID,
       CompanyName
FROM Customers
WHERE UPPER(LTRIM(CompanyName)) LIKE CONCAT(@pMAIN_2507192101282840260, @pMAIN_2507192101282840261);


            
        

Parameters (If used)

Query Results 4:

5. Usage of LTRIM to show first 5 letters of product

SQL Server Query 5

            
 SELECT TOP 5  

     ProductID,  

     ProductName,  

     SUBSTRING(LTRIM(ProductName), 1, 5) AS FirstFiveTrimmed  

 FROM  

     Products  

 ORDER BY ProductID DESC  

            
        

Create SQL query with SqlQueryBuilder 5

            
 var (sql5, parameters5) = new SqlQueryBuilder()  

     .Select().Top(5)  

     .Columns("ProductID", "ProductName")  

     .Column(new SUBSTRING(new LTRIM(new Column("ProductName")), 1, 5), "FirstFiveTrimmed")  

     .From("Products")  

     .OrderBy(new OrderBy().SetColumnDescending("ProductID"))  

     .Build();  

            
        

Query build by SqlQueryBuilder 5

            
SELECT TOP 5 ProductID,
             ProductName,
             SUBSTRING(LTRIM(ProductName), @pMAIN_2507192101282872130, @pMAIN_2507192101282872131) AS FirstFiveTrimmed
FROM Products
ORDER BY ProductID DESC;


            
        

Parameters (If used)

Query Results 5: