Not a horrendous example, but it's late and I feel like I'm missing something here.

Possibly a "homework" question?

Kavi, such a query is simple, but you will still have to define the synonyms. You may be able to search the internet and find some...

No, Grant... you get a Threadaholics Anonymous pin after you abstain from posting to The Thread for a whole day... then a whole week... then a whole... dangit ... now...

I've been told my work is half-fast.

Yes, I heard...

That I didn't hear...

Or maybe I did...

I think I'll go back out and come back in and start all over from...

Just for informational purposes, there is a separate forum for SQL 7/SQL 2000 queries. When you post in SQL2k5 the assumption is that you have access to...

You're welcome, gnethery.

You will find much to like in SQL 2005, and more to come in 2008. Good luck with that.

Hey Roy, didn't you hear? They started another thread that was invitation-only and you and I didn't make the cut.

... just kidding...

... at least to my knowledge......

Flo, I think you have a winner. I don't believe I can improve on that in a single query, since I had begun a similar approach before being...

I've never had the pleasure of visiting Germany, Flo. Perhaps one day. It's nice to "meet" you.

No problem, Flo.

Florian is a new name to me. May I ask if you are a man or a woman? I try to keep things straight...

Yes, that is most certainly the problem. Hang on a minute and I'll give you an SQL2000 solution.

For the future, if you have questions post them in the...

I live in Oxford, and your name seemed familiar. That's all. 🙂

Understood. Sorry I'm no more help. Maybe someone else can help you out.

By the way, have you ever lived in Oxford, MS?

Kavi, could you give us an example of what you are trying to do? Some sample inputs and expected output would be most helpful.