>So it would be much better if I could do something like create UDF's to get the data I need from the lookup tables and use those UDF's in the select in my main SP?

Well, what are you creating a 'look up' table for? Can't all your work be done in one select, using a join to get the 'lookup' data?

BOb