DeLorme 6 - Manual (Page 183)

Working With GIS
175
CEILING CEILING(
numeric_expression )
Returns the smallest integer greater
than or equal to a number. The
result type is integer_expression.
CHARINDEX CHARINDEX(
string_expression ,
string_expression [,
integer_expression] )
Returns the index to the beginning
of the first string expression in
second string. An optional starting
location may be specified. The result
type is integer_expression.
CONTAINS CONTAINS(
string_expression ,
string_expression )
Return TRUE if the first string
contains an instance of the second
string, and FALSE otherwise. The
result type is logical_expression.
COUNT COUNT Return the number of rows in table.
The result type is
integer_expression.
DATEADD DATEADD( datepart,
numeric_expression,
date_expression )
Returns a new datetime value based
on adding an interval to the
specified date, in units specified by
datepart. The result type is
date_expression.
DATEDIFF DATEDIFF( datepart,
date_expression,
date_expression )
Returns the interval between two
datetime values, in units specified
by datepart. The result type is
integer_expression.
DATENAME DATENAME( datepart,
date_expression )
Returns a string representing the
specified datepart of the specified
date. The result type is
string_expression.
DATEPART DATEPART( datepart,
date_expression )
Returns an integer representing the
specified datepart of the specified
date. The result type is
integer_expression.
DAY DAY( date_expression ) Returns an integer representing the
day datepart of the specified date.
The result type is
integer_expression.
EQUALS expression EQUALS
expression
Returns TRUE if the two expressions
are equal and FALSE otherwise.
'EQUALS' is synonymous with the '='
operator. The result type is
logical_expression.
FLOOR FLOOR(
numeric_expression )
Returns the largest integer less than
or equal to a number. The result
type is integer_expression.
GETDATE GETDATE() Returns the current date/time as a
datetime value. The result type is