Category: ASE: Functions: String Functions

isnumeric()

The string function isnumeric() determines if an expression, specfied in the parameter of the function, is a valid numeric datatype. The return value can either be "1", if the expression is a valid integer, floating point number, money or decimal datatype, and "0", if the expression is not a valid numeric value, or if the value of the parameter is NULL. Currency symbols can be part of the expression to be evaluated. The function isnumeric() is available in ASE starting with version 15.0.1.

Syntax of the String Function isnumeric()

    isnumeric(expression)
    

The Parameter of the String Function isnumeric()

"expression"
The parameter "expression" can consist of a variable, constant or a column name.

Example for the String Function isnumeric()

     select isnumeric(12)

     go

    

    -----------

              1

    

The return value of the function isnumeric is "1", i.e the specified expression ("12") a valid numeric value.

    select name,isnumeric(dbid) from master..sysdatabases where name = "tempdb"

    go

    

    name

    ------------------------------ -----------

    tempdb                                   1

    

    

The return value is "1", i.e. the value in the column dbid is a valid numeric value for database tempdb.

See also:

ASE T-SQL - Aggregate Functions,
ascii(),
char(),
char(n),
charindex(),
char_length(),
compare(),
difference(),
lower(),
ltrim(),
patindex(),
replicate(),
reverse(),
right(),
rtrim(),
sortkey(),
soundex(),
space(),
str(),
String Functions,
stuff(),
substring(),
to_unichar(),
uhighsurr(),
ulowsurr(),
upper(),
uscalar().