SQLMetaPhone icon indicating copy to clipboard operation
SQLMetaPhone copied to clipboard

Eliminate NOT in the ELSE IF condition below

Open sgpeele opened this issue 8 years ago • 0 comments

/* 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;

sgpeele avatar Feb 21 '17 01:02 sgpeele