ISDATETIME (stringOrColumnName , patternArray )

ISDATETIME returns true if one of the patterns from the pipe delimited pattern array.

Function Call:

SELECT ISDATETIME('20170402', 'MM/dd/yyyy|yyyyMMdd');

ISBOOL (stringOrColumnName )

ISBOOL returns true if the string or column name can be parsed as boolean values. Supported inputs are 1, 0, and case insensitive variants of 'True' and 'False'.

Function Call:

SELECT ISBOOL(1);

ISBYTE (stringOrColumnName )

ISBYTE returns true if the string or column name can be parsed as byte values.

Function Call:

SELECT ISBYTE(1);

ISSBYTE

ISSBYTE returns true if the string or column name can be parsed as signed byte values.

Function Call:

SELECT ISSBYTE(1);

ISSHORT

ISSHORT returns true if the string or column name can be parsed as short values.

Function Call:

SELECT ISSHORT(1);

ISUSHORT

ISUSHORT returns true if the string or column name can be parsed as unsigned short values.

Function Call:

SELECT ISUSHORT(1);

ISINT

ISINT returns true if the string or column name can be parsed as integer values.

Function Call:

SELECT ISINT(1);

ISUINT

ISUINT returns true if the string or column name can be parsed as unsigned integer values.

Function Call:

SELECT ISUINT(1);

ISLONG

ISLONG returns true if the string or column name can be parsed as long values.

Function Call:

SELECT ISLONG(1);

ISULONG

ISULONG returns true if the string or column name can be parsed as unsigned long values.

Function Call:

SELECT ISULONG(1);

ISFLOAT

ISFLOAT returns true if the string or column name can be parsed as float values.

Function Call:

SELECT ISFLOAT(1);

ISDOUBLE

ISDOUBLE returns true if the string or column name can be parsed as double values.

Function Call:

SELECT ISDOUBLE(1);

ISDECIMAL

ISDECIMAL returns true if the string or column name can be parsed as decimal values.

Function Call:

SELECT ISDECIMAL(1);

ISCHAR

ISCHAR returns true if the string or column name can be parsed as char values.

Function Call:

SELECT ISCHAR(1);

ISTIMESPAN

ISTIMESPAN returns true if the string or column name can be parsed as timespan values.

Function Call:

SELECT ISTIMESPAN(1);

ISURI

ISURI returns true if the string or column name can be parsed as URI values.

Function Call:

SELECT ISURI(1);