yep, i guess a book sounds like a smart idea... thanks for tho specific tip.

thanks! you guys rule! it works just fine...

thanks guys! this worked great on my sql server! there's one more problems with these queries: it should work on access mdbs (jet-sql) and sql server at the same time......