Datatype Checks
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);