> For the complete documentation index, see [llms.txt](https://docs.keyfax.biz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.keyfax.biz/product-suite/admin/entities/questions/dynamic-lists/dynamic-list-examples.md).
# Dynamic List Examples
Various examples showing how to use the Dynamic List question type within Keyfax.
Dynamic Lists can be used to present any data from a SQL Server database during a Keyfax script. On this page we provide a few common examples to help you get started with Dynamic Lists.
### Joining Multiple Columns into a single Dynamic List
You may have data in different table columns that you wish to display as a single list via a Dynamic List question type. To acheive this you can use the SQL `UNION` operator as demonstrated below.
In this example we'll query for 3 phone numbers for the current caller from different table columns and display found phone numbers within a Dynamic List. You can see the SQL below\...
The results are shown below. In this example only 2 phone numbers were found...
#### Handling NULLs
If your columns allow and contain nulls you may need to filter out the null values so these don't appear in the Dynamic List as shown below\...
