---
schema_version: "1"
id: d353fac899b7a52517dcb0efb949d9727f2a50457b1fac8cac1f17133026f8f4
title: Operators
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_es_data_extension_operators.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_es_data_extension_operators.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: d2fe8661665af89939d4848265613f4e606b0f09c5b3e91b1f61b13a917563e3
description: Learn about the expression operators that you can use with profile and preference attributes in data extensions.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# Operators

Learn about the expression operators that you can use with profile and preference attributes in data extensions.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:33.33333333333333%">
          <col style="width:66.66666666666666%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d26013e38">Function</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d26013e41">Description</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 "><strong class="uicontrol">is equal to</strong></td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">The results include subscribers with an attribute definition that exactly
              matches the value. You can specify only one value.</td>

          </tr>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 "><strong class="uicontrol">is not equal to</strong></td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">The results include subscribers with an attribute definition that doesn’t match
              the value. You can specify only one value.</td>

          </tr>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 ">
              <ul>
                <li><strong class="uicontrol">is greater than</strong></li>

                <li><strong class="uicontrol">greater than</strong></li>

                <li><strong class="uicontrol">equal to</strong></li>

              </ul>
            </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">The results include subscribers with an attribute definition that’s greater
              than (or greater than or equal to) the specified value. Use these operators only
              with numeric attributes. </td>

          </tr>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 ">
              <ul>
                <li><strong class="uicontrol">is less than</strong></li>

                <li><strong class="uicontrol">less than</strong></li>

                <li><strong class="uicontrol">equal to</strong></li>

              </ul>
            </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">The results include subscribers with an attribute definition less than (or less
              than or equal to) the value. Use these operators only with numeric
              attributes.</td>

          </tr>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 "><strong class="uicontrol">begins with</strong></td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">The results include attribute values that begin with the exact sequence of
              characters that you specified. Commas are treated as characters and not as
              delimiters. Search strings aren’t case-sensitive.</td>

          </tr>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 ">
              <strong class="uicontrol">contains</strong>
            </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">The results include attribute values that include the specified string. Commas
              are treated as characters and not as delimiters. Search strings aren’t
              case-sensitive.</td>

          </tr>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 ">
              <strong class="uicontrol">does not contain</strong>
            </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">The results include attribute values that don’t contain the specified string.
              Commas are treated as characters and not as delimiters. Search strings aren’t
              case-sensitive.</td>

          </tr>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 "><strong class="uicontrol">ends with</strong></td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">The results include attribute values that end with the exact sequence of
              characters that you specified. Commas are treated as characters and not as
              delimiters. Search strings aren’t case-sensitive.</td>

          </tr>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 "><strong class="uicontrol">exists in</strong></td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">
              <p style="margin-bottom:0;">The results include subscribers with an attribute definition that matches one of
                the values you define in a comma-delimited list of values. This operator looks for
                a partial match of the entire value. For example, if your match criteria is
                <kbd>north</kbd>, this operator matches subscribers with attribute
                values of <code>north</code>, <code>northwest</code>, and
                <code>northeast</code>.
              </p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 "><strong class="uicontrol">exists in whole word</strong></td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">The results include subscribers for which the entire value of the attribute
              matches one of the values you define. You can specify a comma-delimited list of
              values. For example, if your match criteria are <kbd>2326,5308</kbd>,
              this operator returns only subscribers where the entire value of the attribute is
              <kbd>2326</kbd> or <kbd>5308</kbd>.
            </td>

          </tr>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 "><strong class="uicontrol">does not exist in</strong></td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">
              <p style="margin-bottom:0;">The results include subscribers with an attribute definition that doesn’t match
                any of the specified values. You can specify a comma-delimited string of values.
                This operator isn’t applicable when you choose an attribute that has restricted
                values, because you can select only one of the restricted values as the comparison
                value. Search strings aren’t case-sensitive.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 ">
              <strong class="uicontrol">is empty</strong>
            </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">The results include subscribers for which the specified field doesn’t contain
              any content.</td>

          </tr>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 ">
              <strong class="uicontrol">is not empty</strong>
            </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">The results include subscribers for which the specified field contains content
              (that is, the value of the field isn't blank).</td>

          </tr>
          <tr class="">
            <td data-label="Function" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e38 "><strong class="uicontrol">is</strong></td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d26013e41 ">The results include subscribers that have a true or false value for the
              specified attribute.</td>

          </tr>
        </tbody>
      </table>