I need to concatinate a firstname, middle name, and last name fields in a employee lookup query so that a select item on a form shows an employee's full name. I used to do that with a stored procedure in the database and just call it with DW. Is this possible with the Database Connector's query ability?

Hi Peter,
Are those stored in 3 different database fields?

Hello,

Yes, they are stored in multiple fields.

Hi Peter,
You can add the names like:
...
<option...>{{firstname}} {{secondname}} {{thirdname}}</option>
...