Updated: 30 April 2009
Use 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.
SELECT [wctString].[wct].[FIND] (
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.
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.
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.
· 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)
,'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.'
This produces the following result
(1 row(s) affected)