Filter
Top Products
13-57
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter 13 Managing Reports
Organizing Report Data
LIKE(str) Displays True if the values match, and False
otherwise. Use SQL syntax to specify the string
pattern.
The following rules apply:
• Literal pattern characters must match exactly.
LIKE is case-sensitive.
• A percent character (%) matches zero or more
characters.
• An underscore character (_) matches any single
character.
• Escape a literal percent, underscore, or
backslash character (\) with a backslash
character.
LIKE([customerName], "D%")
LIKE([quantityOrdered], "2_")
LOWER(str) Displays the string in a specified column in
lowercase.
LOWER([cityName])
MAX(expr) Displays the highest value in the specified column.
MAX([OrderTotal])
MAX(expr, groupLevel) Displays the highest value for the expression at the
specified group level.
MAX([OrderTotal], 2)
MEDIAN(expr) Displays the median value in a specified column.
MEDIAN([HomePrices])
MEDIAN(expr,
groupLevel)
Displays the median value for the expression at the
specified group level.
MEDIAN([HomePrices], 2)
MIN(expr) Displays the lowest value in the specified column.
MIN([OrderTotal])
MIN(expr, groupLevel) Displays the lowest value for the expression at the
specified group level.
MIN([OrderTotal], 1)
MOD(num, div) Displays the remainder after a number is divided by
a divisor. The result has the same sign as the divisor.
MOD([Salary], 12)
MONTH(date) Displays the name of the month for a specified
date-and-time value.
MONTH([ForecastShipDate])
MONTH(date, option) Displays the month of a specified date-and-time
value, in one of three optional formats:
• 1 - Displays the month number of 1 through 12.
• 2 - Displays the complete month name in the
user’s locale.
• 3 - Displays the abbreviated month name in the
user’s locale.
MONTH([Semester], 2)
MOVINGAVERAGE
(expr, window)
Displays an average value over a specified window,
such as an average price or volume over a number
of days.
MOVINGAVERAGE([Price],
[Days])
NOTNULL(value) For a specified column, displays True if a data value
is not empty. Displays False if a data value is empty.
NOTNULL([DepartmentID])
NOW( ) Displays the current time stamp.
NOW([PastDueDate])
Table 13-11 Examples of Functions (continued)
Function Description Example of use