vedi i seguenti link
https://www.vbforums.com/showthread.php?150582-Sorting-Dates-in-MSFlexGrid
http://helpcentral.componentone.com/docs/vsflexgrid8/sortproperty.htm
ecco il testo sql
select cognome , nome
,(select max(v) from ( values (cognome) , (nome) ) AS MyTable(v) ) as tt
from persone