Other LEFT SQL function

1. Usage of LEFT to show First Letter of company

SQL Server Query 1

            
 SELECT CustomerID, CompanyName, CHAR(ASCII(LEFT(CompanyName, 1))) AS FirstLetterCharacter FROM Customers;   

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Columns("CustomerID", "CompanyName")  

     .Column(new CHAR(new ASCII(new LEFT(new Column("CompanyName"), 1))), "FirstLetterCharacter")  

     .From("Customers")  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT CustomerID,
       CompanyName,
       CHAR(ASCII(LEFT(CompanyName, @pMAIN_2512060918529931870))) AS FirstLetterCharacter
FROM Customers;


            
        

Parameters (If used)

Query Results 1:

2. Usage of LEFT in WHERE clause

SQL Server Query 2

            
 SELECT CustomerID, CompanyName FROM Customers WHERE ASCII(LEFT(CompanyName, 1)) = 65;   

            
        

Create SQL query with SqlQueryBuilder 2

            
 var (sql2, parameters2) = new SqlQueryBuilder()  

     .Select().Columns("CustomerID", "CompanyName")  

     .From("Customers")  

     .Where(new Where(new ASCII(new LEFT(new Column("CompanyName"), 1)).Equale(65)))  

     .Build();  

            
        

Query build by SqlQueryBuilder 2

            
SELECT CustomerID,
       CompanyName
FROM Customers
WHERE ASCII(LEFT(CompanyName, @pMAIN_2512060918530070790)) = @pMAIN_2512060918530070791;


            
        

Parameters (If used)

Query Results 2:

3. Usage of LEFT in WHERE clause

SQL Server Query 3

            
 SELECT ProductID, ProductName FROM Products WHERE ASCII(LEFT(ProductName, 1)) BETWEEN 65 AND 90;   

            
        

Create SQL query with SqlQueryBuilder 3

            
 var (sql3, parameters3) = new SqlQueryBuilder()  

     .Select().Columns("ProductID", "ProductName")  

     .From("Products")  

     .Where(new Where(new BETWEEN(new Column(new ASCII(new Column(new LEFT(new Column("ProductName"), 1)))), 65, 90)))  

     .Build();  

            
        

Query build by SqlQueryBuilder 3

            
SELECT ProductID,
       ProductName
FROM Products
WHERE ASCII(LEFT(ProductName, @pMAIN_2512060918530113370)) BETWEEN @pMAIN_2512060918530113371 AND @pMAIN_2512060918530113372;


            
        

Parameters (If used)

Query Results 3:

4. Usage of LEFT to show first character in OrderID

SQL Server Query 4

            
 SELECT TOP 15 OrderID, CHAR(LEFT(CAST(OrderID AS VARCHAR), 1) + 48) AS FirstDigitAsChar   

 FROM Orders   

 WHERE OrderID BETWEEN 10248 AND 10250;  

            
        

Create SQL query with SqlQueryBuilder 4

            
 var (sql4, parameters4) = new SqlQueryBuilder()  

     .Select().Top(15).Column("OrderID", "OrderID")  

     .Column(new CHAR(new LEFT(new CAST(new Column("OrderID"), SqlDataType.VARCHAR), 1).AddArithmatic(new Arithmatic().Add(48))), "FirstDigitAsChar")  

     .From("Orders")  

     .Where(new Where(new BETWEEN(new Column("OrderID"), 10248, 10250)))  

     .Build();  

            
        

Query build by SqlQueryBuilder 4

            
SELECT TOP 15 OrderID AS OrderID,
              CHAR(LEFT(CAST (OrderID AS VARCHAR), @pMAIN_2512060918530161990) + @pMAIN_2512060918530161991) AS FirstDigitAsChar
FROM Orders
WHERE OrderID BETWEEN @pMAIN_2512060918530161992 AND @pMAIN_2512060918530161993;


            
        

Parameters (If used)

Query Results 4:

5. Typical use of LEFT in WHERE clause

SQL Server Query 5

            
 SELECT CustomerID, CompanyName   

 FROM Customers   

 WHERE CONCAT(LEFT(CompanyName, 1), RIGHT(CompanyName, 1)) = 'AS'  

            
        

Create SQL query with SqlQueryBuilder 5

            
 var (sql5, parameters5) = new SqlQueryBuilder()  

     .Select().Columns("CustomerID", "CompanyName")  

     .From("Customers")  

     .Where(new Where(new CONCAT(  

         new LEFT(new Column("CompanyName"), 1),  

         new RIGHT(new Column("CompanyName"), 1)  

     ).Equale("AS")))  

     .Build();  

            
        

Query build by SqlQueryBuilder 5

            
SELECT CustomerID,
       CompanyName
FROM Customers
WHERE CONCAT(LEFT(CompanyName, @pMAIN_2512060918530204450), RIGHT(CompanyName, @pMAIN_2512060918530204451)) = @pMAIN_2512060918530204452;


            
        

Parameters (If used)

Query Results 5: