Kusto String Functions with Case Sensitivity | Kusto Query Language Tutorial (KQL)

Topic: Kusto String Functions with Case Sensitivity In Kusto Query Language.

In this article, we are going to learn about case sensitive data often we have data in the table that's start with the uppercase lowercase and all that and sometimes we really want to find out that data or get the data that is specific to that case sensitivity, Kusto Query Language is a powerful tool to explore your data and discover patterns, identify anomalies and outliers, create statistical modeling, and more. 

 //contains_cs - Case Senstive  
 //Let's create a table Customer  
 //.drop table Customer  
 .create table Customer (CustomerId: long, FName: string,LName:string )   
  .ingest inline into table Customer <|  
 1,Aamir,Shahzad  
 2,Raza,Ali  
 3,Lisa,River  
 4,steve,Ladson  
 5,Robert,Jr  
 ,aamir,ali  
 // Get you all by ignoring case senstivity  
 Customer  
 | where FName contains "aamir"  
 //How to make sure you get what you want - Case senstive  
 Customer  
 | where FName contains_cs "aamir"  
 // Get only what exactly matches in Case  
 Customer  
 | where FName in ("aamir")  
 // in clause with ignoring case senstivity  
 Customer  
 | where FName in~("aamir")  
 // startswith_cs and startswith  
 Customer  
 | where FName startswith "aa"  
 Customer  
 | where FName startswith_cs "Aa"  
 //endswith and endswith_cs  
 Customer  
 | where FName endswith "IR"  
 Customer  
 | where FName endswith_cs "ir"  

Video Demo: Kusto String Functions with Case Sensitivity | Kusto Query Language Tutorial (KQL)