Other UNICODE SQL function

1. Usage of UNICODE to show unicode of first character in contact name

SQL Server Query 1

            
 SELECT TOP 10   

 	UNICODE(ContactName) AS UnicodeOfFirstChar, ContactName  

 FROM Customers;  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select().Top(10)  

     .Column(new UNICODE(new Column("ContactName")), "UnicodeOfFirstChar")  

     .Column("ContactName", "ContactName")  

     .From("Customers")  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT TOP 10 UNICODE(ContactName) AS UnicodeOfFirstChar,
              ContactName AS ContactName
FROM Customers;


            
        

Parameters (If used)

Query Results 1: