UFN_CONSITTUENT_FUZZY_LOOKUP_SCORE

Calculates scores for fuzzy lookup

Return

Return Type
decimal(5, 2)

Parameters

Parameter	Parameter Type	Mode
@CONFIG_FLAG	bit	IN
@SOURCE	nvarchar(max)	IN
@TARGET	nvarchar(max)	IN

Definition

Copy



CREATE FUNCTION  [dbo].[UFN_CONSITTUENT_FUZZY_LOOKUP_SCORE]
(    
     @CONFIG_FLAG    AS bit
    ,@SOURCE        AS nvarchar(max)
    ,@TARGET        AS nvarchar(max)
)
RETURNS decimal(5,2)
AS
BEGIN
    RETURN(
        SELECT 
        CASE 
            WHEN @CONFIG_FLAG= 1 AND LEN(@TARGET)>0 THEN [dbo].[UFN_FUZZYSTRINGCOMPARER_COMPARESTRINGS](LOWER(@SOURCE), LOWER(@TARGET))
            WHEN @CONFIG_FLAG= 1 AND LEN(@TARGET)=0 THEN 0
            WHEN @CONFIG_FLAG= 0 THEN 0        
            ELSE 0
        END
    );
END