Brilliant Database Software - Home
Database software - Online Help System

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index

Formatting Data

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
Formatting Data

Formatting determines in what way available data will be presented. For example, the number 1499.95 may be presented as $1'499.95 or as ~1500. Or, the name of a person may be displayed as Gomer J. Simpson or Simpson G. Formatting is responsible for that.

Formatting is also used to work with text lines (transform the text to the upper case, replace a part of a line, get first N characters and so on).

Using Formatting
Formatting Numbers
Formatting Date and Time
Formatting Text
Formatting Recordset Variables