Yes sorry forgot to mention that the select statement is currently in a Stored Procedure.

Thanks....I'll throw another question at you. I have a UDF which is called from a select statement which goes after several tables to get results. Based on what...

Thanks ever so much. That is exactly what I want.