Total Page Preview:   000000002570

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



Comments