Specific Data Functions

The Database Tour has a large set of functions for different types of database fields like text, numeric, graphic etc. Some of them of course can be executed using Database Tour SQL tools, but having specific GUI often simplifies the task.

Batch Operations with Text Fields

You can use several useful functions for selected fields of a dataset: trimming, changing case of symbols etc.

Batch Operations with Text Fields

Calculating Data in Numeric Fields

You can perform several arithmetic operations like sum, average, min, max with a certain numeric field of the open dataset without needing to write a SQL query for that.

Calculating Data in Numeric Fields

Searching and Replacing Text in DB

You can search and replace text in database tables or queries (including BLOB and CLOB fields) as long as in interface parts of the program.

Find and Replace Text in Database

Blob Viewer and Editor

Working with large text from BLOB and CLOB fields or graphic data is possible in the Blob Editor.

Blob Editor