IsInteger

Table of Contents

Overview
Prototype

Example

See also
Related

Overview

Returns true (1) if the given value is a whole number, with an optional leading sign.

Prototype

Boolean IsInteger(String value)

Boolean results

Boolean functions return 1 for true and 0 for false. In a WHERE clause compare the result to 1 (or true), for example: WHERE IsLike(Text, 'Cat%') = 1

Example

Tests two values.

SELECT IsInteger('15') as WholeNumber, IsInteger('1.5') as Decimal FROM Single

See also

Scalar Functions

Home

The home page

SQL :: Abs

Returns the absolute value of a number.

SQL :: Ceil

Returns the smallest whole number that is greater than or equal to the given number.

SQL :: Checksum

Returns a simple 16-bit checksum (0 to 65535) of the value's ASCII bytes. It is fast but not collision resistant; use Sha256 when the value must be unique.

SQL :: Coalesce

Returns the first of the given values that is not null. Accepts any number of values.

SQL :: Concat

Concatenates all of the given values that are not null. Accepts any number of values. The + operator can also be used to concatenate, but a null on either side of + makes the whole result null.

SQL :: DateAdd

Adds offset intervals to a date/time value and returns the new date/time. Use a negative offset to subtract. Interval names are not case-sensitive.

SQL :: DateDiff

Returns the number of intervals between two date/time values (date2 minus date1). See DateAdd for the interval names.

SQL :: DateTime

Returns the server's current local date and time, formatted with the optional .NET date/time format string.

SQL :: DateTimeUTC

Returns the current UTC date and time, formatted with the optional .NET date/time format string. See DateTime for the format specifiers.