Other ASCII SQL function

1. Usage of ASCII to get ASCII of first letter in Company Name

SQL Server Query 1

            
 SELECT CustomerID, CompanyName, ASCII(CompanyName) AS FirstLetterASCII FROM Customers;   

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Columns("CustomerID", "CompanyName")  

     .Column(new ASCII(new Column("CompanyName")), "FirstLetterASCII")  

     .From("Customers")  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT CustomerID,
       CompanyName,
       ASCII(CompanyName) AS FirstLetterASCII
FROM Customers;


            
        

Parameters (If used)

Query Results 1:

2. Usage of ASCII in WHERE clause

SQL Server Query 2

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

            
        

Create SQL query with SqlQueryBuilder 2

            
 var (sql2, parameters2) = 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 2

            
SELECT ProductID,
       ProductName
FROM Products
WHERE ASCII(LEFT(ProductName, @pMAIN_2507200145499879280)) BETWEEN @pMAIN_2507200145499879281 AND @pMAIN_2507200145499879282;


            
        

Parameters (If used)

Query Results 2: