>I have been working with someone who is a more experienced SQL programmer than I. He suggested that I use functions rather than procedures for single table returns. When I use functions rather than procedures the code compiles without any problem. However, I notice that the BLG does not list the functions. Will using functions cause problems down the line? Thanks.

What is BLG and this is an interesting statement, I'd like more information about it.