Function
Group
|
Available
Functions |
Numeric
|
Random
Range, AutoNumber, Number Flag,
Constant |
Text
|
Random
Characters, Mask/Pattern, Same Text, Text
Flag, Memo, GUID |
Date
& Time
|
Random
Range, AutoDate, Constant, Timestamp |
| Binary |
Text
(BLOB/CLOB), Image |
| Geographical |
Address,
City, State, Postal Code, County, Country,
Region |
| Enterprise |
Company
Name, Industry, Stock Ticker Symbol, Web Site,
Phone |
| Personal |
First
Name, Last Name, Full Name, Salutation, Gender,
Date of Birth, Job Title, Department, Email,
Phone |
| Professional
Edition only |
| Conversion |
CHAR,
TO_NUMBER, TO_DATE, TO_STRING |
| Date |
ADD_DAYS,
ADD_DATETIME, DATETIME_PART, DAY,
MONTH, YEAR, NOW |
| Number |
ABS,
MOD, ROUND, INTEGER |
| String |
CLAN,
INSTR, LEFT, LEN, LOWER, UPER, PROPER, REPLACE,
RIGHT, SUBSTRING, TRIM |
| Runtime |
DECODE,
DISTRIBUTION, GETVAR, IIF, SETVAR |
|
|
|
