CEILING (NoSQL query)

APPLIES TO: NoSQL

Returns the smallest integer value greater than or equal to the specified numeric expression.

Syntax

CEILING(<numeric_expr>)  

Arguments

	Description
numeric_expr	A numeric expression.

Return types

Returns a numeric expression.

Examples

The following example shows positive numeric, negative, and zero values evaluated with this function.

SELECT VALUE {
    containsPrefix: CONTAINS("AdventureWorks", "Adventure"), 
    containsSuffix: CONTAINS("AdventureWorks", "Works"),
    containsWrongCase: CONTAINS("AdventureWorks", "adventure"), 
    containsWrongCaseValidateCase: CONTAINS("AdventureWorks", "adventure", false), 
    containsWrongCaseIgnoreCase: CONTAINS("AdventureWorks", "works", true),
    containsMismatch: CONTAINS("AdventureWorks", "Contoso")
}

[
  {
    "containsPrefix": true,
    "containsSuffix": true,
    "containsWrongCase": false,
    "containsWrongCaseValidateCase": false,
    "containsWrongCaseIgnoreCase": true,
    "containsMismatch": false
  }
]

Remarks

• This system function benefits from a range index.

Related content

• System functions
• FLOOR