FAMILY()

The FAMILY() function returns the name of the optical family in which a TEXT or BYTE data column is stored.

In the following example, the FAMILY() function obtains the family name of the optical platters that contain the data for the cat_picture column:

SELECT FAMILY(cat_picture) FROM catalog WHERE manu_code = 'HRO'

One row of output (family name) is generated for each row where manu_code is equal to HRO.