UPPER SQL function

1. Usage of UPPER to format city for specific countries.

SQL Server Query 1

            
SELECT TOP 20  

    CustomerID,  

    CompanyName,  

    CASE  

        WHEN Country IN ('USA', 'Canada', 'UK') THEN UPPER(City)  

        ELSE City  

    END AS FormattedCity,  

    Country  

FROM Customers  

WHERE Country IN ('Germany','Mexico','France','Spain','USA', 'Canada', 'UK');  

            
        

Create SQL query with SqlQueryBuilder 1

            
var (sql1, parameters1) = new SqlQueryBuilder()  

    .Select().Top(20)  

    .Columns("CustomerID", "CompanyName")  

    .Column(new CASE()  

        .When(new IN(new Column("Country"), "USA", "Canada", "UK")).Then(new UPPER(new Column("City")))  

        .Else(new Column("City"))  

    , "FormattedCity")  

    .Column("Country", "Country")  

    .From("Customers")  

    .Where(new Where(new IN(new Column("Country"), "Germany", "Mexico", "France", "Spain", "USA", "Canada", "UK")))  

    .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT TOP 20 CustomerID,
              CompanyName,
              CASE WHEN Country IN (@pMAIN_2507192014395562480, @pMAIN_2507192014395562481, @pMAIN_2507192014395562482) THEN UPPER(City) ELSE City END AS FormattedCity,
              Country AS Country
FROM Customers
WHERE Country IN (@pMAIN_2507192014395562483, @pMAIN_2507192014395562484, @pMAIN_2507192014395562485, @pMAIN_2507192014395562486, @pMAIN_2507192014395562487, @pMAIN_2507192014395562488, @pMAIN_2507192014395562489);


            
        

Parameters (If used)

Query Results 1:

2. Usage of UPPER to make first letter capital

SQL Server Query 2

            
SELECT TOP 10  

    CustomerID,  

    ContactName,  

    UPPER(LEFT(ContactName, 1)) + SUBSTRING(ContactName, 2, LEN(ContactName)) AS UppercaseFirstLetter  

FROM Customers;  

            
        

Create SQL query with SqlQueryBuilder 2

            
var (sql2, parameters2) = new SqlQueryBuilder()  

    .Select().Top(10)  

    .Columns("CustomerID", "ContactName")  

    .Column(new CONCAT(  

            new UPPER(new LEFT(new Column("ContactName"), 1)),  

            new SUBSTRING(new Column("ContactName"), 2, new LEN(new Column("ContactName")))  

        ), "UppercaseFirstLetter")  

    .From("Customers")  

    .Build();  

            
        

Query build by SqlQueryBuilder 2

            
SELECT TOP 10 CustomerID,
              ContactName,
              CONCAT(UPPER(LEFT(ContactName, @pMAIN_2507192014395642360)), SUBSTRING(ContactName, @pMAIN_2507192014395642361, LEN(ContactName))) AS UppercaseFirstLetter
FROM Customers;


            
        

Parameters (If used)

Query Results 2:

3. Usage of UPPER to check Region is available with COALESCE and make it capital

SQL Server Query 3

            
SELECT  

    CustomerID,  

    CompanyName,  

    UPPER(COALESCE(Region, 'UNKNOWN')) AS UppercaseRegion  

FROM Customers;  

            
        

Create SQL query with SqlQueryBuilder 3

            
var (sql3, parameters3) = new SqlQueryBuilder()  

    .Select()  

    .Columns("CustomerID", "CompanyName")  

    .Column(new UPPER(new COALESCE(new Column("Region"), "UNKNOWN")), "UppercaseRegion")  

    .From("Customers")  

    .Build();  

            
        

Query build by SqlQueryBuilder 3

            
SELECT CustomerID,
       CompanyName,
       UPPER(COALESCE (Region, @pMAIN_2507192014395701550)) AS UppercaseRegion
FROM Customers;


            
        

Parameters (If used)

Query Results 3:

4. Usage of UPPER to make city capital

SQL Server Query 4

            
SELECT  

    CustomerID, CompanyName,  

    UPPER(City) AS UppercaseCity,  

    Country  

FROM Customers  

ORDER BY UppercaseCity;  

            
        

Create SQL query with SqlQueryBuilder 4

            
var (sql4, parameters4) = new SqlQueryBuilder()  

    .Select()  

    .Columns("CustomerID", "CompanyName")  

    .Column(new UPPER(new Column("City")), "UppercaseCity")  

    .Column("Country", "Country")  

    .From("Customers")  

    .OrderBy(new OrderBy().Set(new Column("UppercaseCity")))  

    .Build();  

            
        

Query build by SqlQueryBuilder 4

            
SELECT CustomerID,
       CompanyName,
       UPPER(City) AS UppercaseCity,
       Country AS Country
FROM Customers
ORDER BY UppercaseCity ASC;


            
        

Parameters (If used)

Query Results 4: