As always, thanks for the help. I will look into both approaches.
>However, as Sergey mentioned, you would be better off if you didn't depend on Dynamic SQL. There are scripts that
www.swynk.com that will parse a comma delimited list. you could then put the values into a temp table.
>
>Play with both approaces.
>
>-Mike
Tim Westmoreland
Software Engineer
Skyline Technologies, Inc.
"Upper classes are a nation's past; the middle class is its future." - Ayn Rand, Russian-born author (1905-1982).