條件式運算子參考 |
「條件式運算子」在條件陳述式中用於確定要在資料來源和指定值之間建立的關係。條件陳述式的結構與句子類似,帶有主詞 (資料來源)、動詞 (運算子)和受詞 (值)。您可以使用條件式運算子執行以下動作:
下表描述了可以與每個條件式運算子一起使用的有效資料類型。
|
可用的條件式運算子可能取決於您要為其建立條件陳述式的功能。還可能取決於連接到文件的資料庫類型。如需有關如何檢視陳述式的可用條件式運算子的資訊,請參閱用於建立條件陳述式的特定對話方塊或屬性頁面的文件。 |
|
條件式運算子 |
有效輸入 |
範例 |
---|---|---|---|
|
Equals |
除「時間」、「二進位」和「圖片」外的所有類型 |
[資料來源] Equals <值> |
|
Does not equal |
除「時間」、「二進位」和「圖片」外的所有類型 |
[資料來源] Does Not Equal <值> |
|
Is greater than |
除「時間」、「二進位」和「圖片」外的所有類型 |
[資料來源] Is greater than <值> |
|
Is greater than or equal to |
除「時間」、「二進位」和「圖片」外的所有類型 |
[資料來源] Is greater than or equal to <值> |
|
Is less than |
除「時間」、「二進位」和「圖片」外的所有類型 |
[資料來源] Is less than <值> |
|
Is less than or equal to |
除「時間」、「二進位」和「圖片」外的所有類型 |
[資料來源] Is less than or equal to <值> |
|
Is between |
除「時間」、「二進位」和「圖片」外的所有類型 |
[資料來源] Is between <值 1> and <值 2> |
|
Is not between |
除「時間」、「二進位」和「圖片」外的所有類型 |
[資料來源] Is not between <值 1> and <值 2> |
|
Contains |
僅限文字 |
[資料來源] Contains <值> |
|
Does not contain |
僅限文字 |
[資料來源] Does not contain <值> |
|
Begins with |
僅限文字 |
[資料來源] Begins with <值> |
|
Ends with |
僅限文字 |
[資料來源] Ends with <值> |
|
Is like |
僅限文字 |
[資料來源] Is like <值> |
|
Is not like |
僅限文字 |
[資料來源] Is not like <值> |
|
Is Null |
僅限 SQL |
[資料來源] Is Null |
|
Is Not Null |
僅限 SQL |
[資料來源] Is Not Null |
|
Is Empty |
僅限文字 |
[資料來源] Is Empty |
|
Is Not Empty |
僅限文字 |
[資料來源] Is Not Empty |
|
Is blank |
所有資料類型 |
[資料來源] Is blank |
|
Is not blank |
所有資料類型 |
[資料來源] Is not blank |
|
Is any of |
除「時間」、「二進位」和「圖片」外的所有類型 |
[資料來源] Is any of <值 1>, <值 2>, <值 3>... |
|
Is none of |
除「時間」、「二進位」和「圖片」外的所有類型 |
[資料來源] Is none of <值 1>, <值 2>, <值 3>... |
|
Is beyond this year |
僅限日期 |
[資料來源] Is beyond this year |
|
Is later this year |
僅限日期 |
[資料來源] Is later this year |
|
Is later this month |
僅限日期 |
[資料來源] Is later this month |
|
Is next week |
僅限日期 |
[資料來源] Is next week |
|
Is later this week |
僅限日期 |
[資料來源] Is later this week |
|
Is tomorrow |
僅限日期 |
[資料來源] Is tomorrow |
|
Is today |
僅限日期 |
[資料來源] Is today |
|
Is yesterday |
僅限日期 |
[資料來源] Is yesterday |
|
Is earlier this week |
僅限日期 |
[資料來源] Is earlier this week |
|
Is last week |
僅限日期 |
[資料來源] Is last week |
|
Is earlier this month |
僅限日期 |
[資料來源] Is earlier this month |
|
Is earlier this year |
僅限日期 |
[資料來源] Is earlier this year |
|
Is prior this year |
僅限日期 |
[資料來源] Is prior this year |
相關主題