LEN SQL function

1. Usage of LEN to find company's name lenght.

SQL Server Query 1

            
SELECT TOP 5  

	CustomerID,  

	CompanyName,  

	LEN(CompanyName) AS CompanyNameLength  

FROM  

	Customers  

ORDER BY LEN(CompanyName) DESC;  

            
        

Create SQL query with SqlQueryBuilder 1

            
var (sql1, parameters1) = new SqlQueryBuilder()  

    .Select().Top(5)  

    .Columns("CustomerID", "CompanyName")  

    .Column(new LEN(new Column("CompanyName")), "CompanyNameLength")  

    .From("Customers")  

    .OrderBy(new OrderBy().SetColumnDescending("CompanyName"))  

    .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT TOP 5 CustomerID,
             CompanyName,
             LEN(CompanyName) AS CompanyNameLength
FROM Customers
ORDER BY CompanyName DESC;


            
        

Parameters (If used)

Query Results 1:

2. Usage of LEN in WHERE clause to find specific company's name length

SQL Server Query 2

            
SELECT TOP 5 CustomerID,  

	CompanyName,  

	LEN(CompanyName) AS CompanyNameLength  

FROM Customers  

WHERE LEN(CompanyName) BETWEEN 20 AND 30  

ORDER BY CompanyName DESC;  

            
        

Create SQL query with SqlQueryBuilder 2

            
var (sql2, parameters2) = new SqlQueryBuilder()  

    .Select().Top(5)  

    .Columns("CustomerID", "CompanyName")  

    .Column(new LEN(new Column("CompanyName")), "CompanyNameLength")  

    .From("Customers")  

    .Where(new Where(new BETWEEN(new LEN(new Column("CompanyName")), 20, 30)))  

    .OrderBy(new OrderBy().SetColumnDescending("CompanyName"))  

    .Build();  

            
        

Query build by SqlQueryBuilder 2

            
SELECT TOP 5 CustomerID,
             CompanyName,
             LEN(CompanyName) AS CompanyNameLength
FROM Customers
WHERE LEN(CompanyName) BETWEEN @pMAIN_2507200140484183980 AND @pMAIN_2507200140484183981
ORDER BY CompanyName DESC;


            
        

Parameters (If used)

Query Results 2: