IsEqual

Table of Contents



Returns true (1) if the two given values are equal. The comparison is case-sensitive.

Boolean IsEqual(String text1, String text2)

Boolean results

Boolean functions return 1 for true and 0 for false. In a WHERE clause compare the result to 1 (or true), for example: WHERE IsLike(Text, 'Cat%') = 1


round-pushpin Flags the rows where the English text is exactly 'cats'.
SELECT English, IIF(IsEqual(English, 'cats'), 'Yes', 'No') as IsCats FROM WordList:FlatTranslate