Difference between revisions of "TYPE()"
From Lianjapedia
Helen.george (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
| − | [[ATOH()]], [[BIN2I()]], [[BIN2L()]], [[BIN2W()]], [[CAST()]], [[CTOD()]], [[CTOT()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[ERROR()]], [[ERRNO()]], [[ETOS()]], [[HTOA()]], [[I2BIN()]], [[ISALPHA()]], [[ISDIGIT()]], [[L2BIN()]], [[MESSAGE()]], [[MTOS()]], [[STR()]], [[STRZERO()]], [[TTOC()]], [[TTOD()]], [[VAL()]], [[VARTYPE()]], [[VTOD()]] | + | [[ATOH()]], [[BIN2I()]], [[BIN2L()]], [[BIN2W()]], [[CAST()]], [[CTOD()]], [[CTOT()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[ERROR()]], [[ERRNO()]], [[ETOS()]], [[HTOA()]], [[I2BIN()]], [[ISALPHA()]], [[ISDIGIT()]], [[L2BIN()]], [[MESSAGE()]], [[MTOS()]], [[STR()]], [[STRZERO()]], [[TTOC()]], [[TTOD()]], [[TYPEOF()]], [[VAL()]], [[VARTYPE()]], [[VTOD()]] |
==Description== | ==Description== | ||
Revision as of 07:19, 21 March 2019
Contents
Purpose
Function to return a letter code that represents a data type
Syntax
TYPE(<expC>)
See Also
ATOH(), BIN2I(), BIN2L(), BIN2W(), CAST(), CTOD(), CTOT(), DTOC(), DTOM(), DTOS(), DTOV(), ERROR(), ERRNO(), ETOS(), HTOA(), I2BIN(), ISALPHA(), ISDIGIT(), L2BIN(), MESSAGE(), MTOS(), STR(), STRZERO(), TTOC(), TTOD(), TYPEOF(), VAL(), VARTYPE(), VTOD()
Description
The TYPE() function returns a letter code which represents the data type of the expression in <expC>. The return value of the letter code is a character string from the table below.
| Data type | Return Value |
|---|---|
| ARRAY (STATIC) | A |
| ARRAY (DYNAMIC) | O |
| BIGINT | N |
| BIT | L |
| BYTE | N |
| CHARACTER | C |
| CURRENCY | Y |
| DATE | D |
| DATETIME | T |
| DECIMAL | N |
| DOUBLE | N |
| FLOAT | N |
| GENERAL | G |
| INTEGER | N |
| LOGICAL | L |
| LONG VARCHAR | M |
| LONG VARBINARY | G |
| MEDIUMINT | N |
| MEMO | M |
| NUMERIC | N |
| OBJECT | O |
| PACKED | N |
| QUAD | N |
| REAL | N |
| SHORT | N |
| SMALLINT | N |
| Syntax error | U |
| TEXT | M |
| TIME | C |
| TIMESTAMP | T |
| TINYINT | N |
| Undefined | U |
| VAXDATE | C |
| VARCHAR | C |
| ZONED NUMERIC | C |
Example
i = 10 ? type("i") N
