Micro Focus XDBC has a number of built-in functions that help you create your SQL statements. You can use them in the SELECT-list to modify the result set or in the WHERE clause to limit the number of qualifying rows. They are also valid in INSERT, UPDATE, and DELETE statements.