exact() Function

Function

exact( text1, text2 )

Compares two given text strings in a case-sensitive manner, returning true only if they are exactly the same.

See also: Comparison Operators

Parameters

Returns

Boolean

Usage considerations

When comparing text strings, using this function over the = operator improves performance. The = operator, however, is case-insensitive. Only use the exact() function when case-insensitivity is not a requirement.

Examples

Text

Comparing exact copies

1
exact("HELLO", "HELLO")

Returns true.

Comparing text that differs only by case

1
exact("Hello", "HELLO")

Returns false.

Comparing different text

1
exact("Hello", "World")

Returns false.

Other Types

Comparing non-text values

1
exact(123, 123)

Returns true. Values of other scalar types are compared in the same way as =.

Comparing text from a dictionary without casting

1
2
3
4
exact(
  "Hello",
  { dictionaryKey: "Hello" }.dictionaryKey
)

Returns false. Cast dictionary values to text before comparing using the exact() function.

Comparing text from a map or CDT

1
2
3
4
exact(
  "Hello",
  a!map( mapKey: "Hello" ).mapKey
)

Returns true. Map values do not need to be cast before comparing.

Comparing lists and single values

1
exact({ "Hello" }, "Hello")

Returns false. Lists are not considered equal to scalar values.

Feature compatibility

Feedback