Total Page Preview: 000000018065
How to use SUBSTRING method in azure DocumentDB
In this article we will learn SUBSTRING method in azure Documentdb.
SUBSTRING Method
The SUBSTRING Method will Returns part of a string expression starting at the specified character zero-based position and continues to the specified length, or to the end of the string..
Syntax
SUBSTRING(<str_expr>, [Start Index], [End Index])
Example:
SELECT SUBSTRING ("Brijesh" , 1, 5)
Result:
[{"$1":"rijes"}]
OUTPUT
Thanks
Brijesh Kumar
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com