SUBSTRING and CHARINDEX functions are two of the most commonly used string functions in SQL. They allow you to extract and search for substrings within strings. SUBSTRING: The SUBSTRING function is ...

PATINDEX. CHARINDEX Pattern search. Yes. No Wildcards. Yes. No Exact search. No. Yes Performance. Slower. Faster Index friendly. Less. More One-Line Answer PATINDEX is used for pattern-based searching ...

@value = RTRIM(LTRIM(SUBSTRING(@listOfValues,1,CHARINDEX(@delimiter, @listOfValues,0)-1))), @listOfValues = RTRIM(LTRIM(SUBSTRING(@listOfValues, CHARINDEX(@delimiter ...

WHEN CHARINDEX('Buildings Or Structure', descriptivegroup) > 0 THEN 'Building Text' WHEN CHARINDEX('Inland Water', descriptivegroup) > 0 THEN 'Water Text' WHEN CHARINDEX('Road Or Track', ...