SQLMetaPhone
SQLMetaPhone copied to clipboard
Eliminate NOT in the ELSE IF condition below
/* B -> B unless at the end of word after "m", as in "dumb", "Comb" */
ELSE IF @This = 'B' AND ((@ii = @Len) AND (@Previous = 'M')) BEGIN SELECT @Metaphone = substring(@Metaphone, 1, @Len-1); END; ELSE IF @This = 'B' BEGIN SELECT @Metaphone = @Metaphone + 'B'; END;