ADO.NET Provider for Excel Services

Build 20.0.7587

Predicate Functions

CEILING(value)

Returns the value rounded up to the nearest whole number (no decimal component).

  • expression: The value to round.

CONCAT(string_expr1, string_expr2)

Returns the string that is the concatenation of string_expr1 and string_expr2.

  • string_expr1: The first string to be concatenated.
  • string_expr2: The second string to be concatenated.

DAY(datetime_date)

Returns the integer that specifies the day component of the specified date.

  • datetime_date: The datetime string that specifies the date.

ENDSWITH(string_expression, string_suffix)

Returns true if string_expression ends with string_suffix, otherwise returns false.

  • string_expression: The string expression to search within.
  • string_suffix: The string suffix to search for.

FLOOR(value)

Returns the value rounded down to the nearest whole number (no decimal component).

  • value: The value to round.

HOUR(datetime_time)

Returns the integer that specifies the hour component of the specified time.

  • datetime_time: The datetime string that specifies the time.

INDEXOF(string_expression, string_search)

Returns the index location where string_search is contained within string_expression.

  • string_expression: The string expression to search within.
  • string_search: The search value to locate within string_expression.

LENGTH(string_expression)

Returns the number of characters of the specified string expression.

  • string_expression: The string expression.

MINUTE(datetime_time)

Returns the integer that specifies the minute component of the specified time.

  • datetime_time: The datetime string that specifies the time.

MONTH(datetime_date)

Returns the integer that specifies the month component of the specified date.

  • datetime_date: The datetime string that specifies the date.

REPLACE(string_expression, string_search, string_replace)

Returns the string after replacing any found string_search values with string_replace.

  • string_expression: The string expression to perform a replace on.
  • string_search: The string value to find within string_expression.
  • string_replace: The string value replace and string_search instances found.

ROUND(value)

Returns the value to the nearest whole number (no decimal component).

  • value: The value to round.

SECOND(datetime_time)

Returns the integer that specifies the second component of the specified time.

  • datetime_time: The datetime string that specifies the time.

STARTSWITH(string_expression, string_prefix)

Returns true if string_expression starts with string_prefix, otherwise returns false.

  • string_expression: The string expression to search within.
  • string_prefix: The string prefix to search for.

SUBSTRINGOF(string_expression, string_search)

Returns true if string_expression contains string_expression, otherwise returns false.

  • string_expression: The string expression to search within.
  • string_search: The value to search for.

TOLOWER(string_expression)

Returns the string_expression with the uppercase character data converted to lowercase.

  • string_expression: The string expression to lowercase.

TOUPPER(string_expression)

Returns the string_expression with the lowercase character data converted to uppercase.

  • string_expression: The string expression to uppercase.

TRIM(string_expression)

Returns the string_expression with the leading and trailing whitespace removed.

  • string_expression: The string expression to trim.

YEAR(datetime_date)

Returns the integer that specifies the year component of the specified date.

  • datetime_date: The datetime string that specifies the date.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587