SQL Server FIND Function

Updated 2023-11-10 19:30:47.543000

Description

Use the scalar function FIND to locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.

Syntax

SELECT [westclintech].[wct].[FIND] (
  <@Find_text, nvarchar(max),>
 ,<@Within_text, nvarchar(max),>
 ,<@Start, int,>)

Arguments

@Find_text

is the text to you want to find. The @Find_text argument can be of data types that are implicitly convertible to nvarchar or ntext.

@Within_text

is the text containing the text you want to find . The @Within_text argument can be of data types that are implicitly convertible to nvarchar or ntext.

@Start

specifies the position at which to start searching @Within_text. The first position in @Within_text is 1. The @Start argument must be of data types that are implicitly convertible to int.

Return Type

int

Remarks

FIND does not support the use of wildcards.

FIND is case sensitive.

If @Start is NULL, FIND starts searching @Within_text at position 1.

IF @Find_text does not appear in @Within_text, FIND returns zero.

0 < @Start_num < LEN(@Within_text)

Examples

select wct.FIND('fathers'
,'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.'
,NULL
)

This produces the following result.

{"columns":[{"field":"column 1","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"column 1":"36"}]}