>I have a function in an SQL statement that sends two numeric parameters to my procedure. I want to return a string value but I keep getting a data type mismatch error. Please help.

And (to add to Sergey's question) have you tried to call this function just from the command window to make sure it works as you expect?