Term
ABSOLUTE(number)
ABS(number)
[Arithmetic] |
|
Definition
| Get the absolute value of a number. |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| Count the number of records. |
|
|
Term
|
Definition
| Count the number of records where a certain field is non-null. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Truncate a number to the nearest integer. |
|
|
Term
CHAR_LENGTH(string)
LEN(string)
[String]
CHARACTER_LENGTH and LENGTH are not accepted. |
|
Definition
| Find the number of characters in a string. |
|
|
Term
LOWER(string)
[String]
LCASE is not accepted. |
|
Definition
| Convert all the uppercase characters in a string to lowercase. |
|
|
Term
UPPER(string)
[String]
UCASE is not accepted. |
|
Definition
| Convert all the lowercase characters in a string to uppercase. |
|
|
Term
SUBSTRING(string, starting position, length)
SUBSTR(string, starting position, length)
MID(string, starting position, length)
[String] |
|
Definition
| Find a substring in a string starting from a certain postion. |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| Get the ASCII code of a character. |
|
|
Term
|
Definition
| Get the numerical value of a string (e.g. '11' -> 11) |
|
|
