MidTextCount

Returns the highest available Index that can be used using the MidText function

Free Function
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

SELECT SQLHTTP.net.MidTextCount ( @Text, @Start, @End )

Arguments:

Name	Type	Description
@Text	nvarchar(MAX)	String expression to extract from
@Start	nvarchar(MAX)	String preceding the substring to be retrieved
@End	nvarchar(MAX)	String proceeding the substring to be retrieved



Return Type:

int



Sample Usage:

Retrieving text surrounded by double brackets:


DECLARE @Text nvarchar(MAX)
DECLARE @Start nvarchar(MAX)
DECLARE @End nvarchar(MAX)

SET @Text = '[[some]] of these [[words]] are in [[double brackets]]'
SET @Start = '[['
SET @End = ']]'

SELECT SQLHTTP.net.MidTextCount(@Text, @Start, @End)

DECLARE @Text nvarchar(MAX)

DECLARE @Start nvarchar(MAX)

DECLARE @End nvarchar(MAX)

SET @Text = '[[some]] of these [[words]] are in [[double brackets]]'

SET @Start = '[['

SET @End = ']]'

SELECT SQLHTTP.net.MidTextCount(@Text, @Start, @End)

-----



MidTextCount

Featured API Wrapper Code / SQL Server