Advanced Lookup column headers

Issue

How do you display column headers in an Advanced Lookup control

Solution

Use a UNION in the SQL query e.g.

Select ‘<b>Heading1</b>’ as column1, ‘<b> Heading2</b>’ as column2
Union
Select column1, column2 from table
Order by column1