>Yes, I know that. But you could Execute first select to get MAX() Synonyms, then build the SELECT String (I suppose in .NET) and then back to OLEDB to run builded string.
>AFAIK there is no easy method to concatenate strings with SELECT command, always have to use functions.
Following that idea, I guess the best would be to do the SQL as is to get the styles. Then, I would do another one to get all the synonyms. Then, when listing the styles, I would query the dataset instead of the synonym SQL result.