Tips, Expertise, Articles and Advice from the Pro's for Your Website or Blog to Succeed
SQL Server offers several types of system functions to meet our business requirements. One such type is configuration functions using which we can get the information about current configuration option settings. These functions operate in a non-deterministic way, which means they may return different values by running these functions with the same inputs.
Today I will showcase the use cases of the below configuration functions in this article.
Today, I will explain a SQL Server string function PATINDEX () used to return an integer value representing the starting position of the first occurrence of a pattern in a specified expression. This function will return zero if the pattern is not found in the specified expression.
The syntax of this function is given below.
This article will explain the T-SQL string function SUBSTRING() and its use cases. SQL Server offers various string functions to meet distinct business requirements. The SUBSTRING () function is one of them which is used to fetch part of a character, binary, text, or image expression in SQL Server. The syntax used for this function is given below.
-- Syntax
SUBSTRING ( expression ,start , length )Here, all 3 arguments are mandatory to pass to get the output. You can understand more about all 3 arguments in the below points.