>>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.
Don't know, but I think that way would be faster. Also my suggestion have one big problem. What would happen if you have 100 synonyms for one style? WOW! That is why I asked first if there is any limitation about how many synonims you could have for one style.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.