Wow...9 gigs burns a lot.  I think i'll stick to the UDF for now.  The distances are only of limited use.  Because not everybody lives in the center of their...

Thanks for the help.  I think i'm going to use dynamic sql in my stored procedure to generate the where clause based on the variables provided.  You're right, when I...

Thanks guys, I appriciate the help.

I know that theoretically, I could use dynamic SQL to create the ordering portion.  I was just wondering if I could do it another way.