# xSQL Sample Functions

> This sample demonstrates the use of several built-in functions including: `sum(), substr(), length(), upper(), lower(), format()` and `count()`. Note the use of the `trace` command to display performance statistics for the queries.

> This sample can be run from directory `samples\xsql\scripts` with the following command:

>         ..\..\..\target\bin\xsql.exe -b -c xsql.cfg -f functions.sql