ENDSWITH

Updated 2023-11-10 19:27:51.727000

Syntax

SELECT [westclintech].[wct].[ENDSWITH] (
  <@Text, nvarchar(max),>
 ,<@Value, nvarchar(max),>
 ,<@CaseSensitive, bit,>)

Description

Use the scalar function ENDSWITH to determine if a string ends with a particular value.

Arguments

@Text

is the text to be searched. The @Text argument can be of data types that are implicitly convertible to nvarchar or ntext.

@CaseSensitive

declares the search as being either case sensitive or case insensitive, regardless of collation. The @CaseSenstive argument must be of data types that are implicitly convertible to bit.

@Value

is the value to search for in @Text. The @Value argument can be of data types that are implicitly convertible to nvarchar or ntext.

Return Type

bit

Remarks

ENDSWITH does not support the use of wildcards.

ENDSWITH supports case sensitive searches. @CaseSensitive = 1, makes the search case sensitive.

Examples

select wct.ENDSWITH('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.'
,'equal.'
,0);

This produces the following result.

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