Thanks again for all of your help. 

Thanks for your help. - I get "Incorrect Syntax near the word 'AS'" when I changed it to "Select @Distance = ".  Any ideas?

Thanks!