I have seen the examples on returning parameters in stored procedures that use the OUTPUT value. I am unclear on the syntax however for returning the actual varchar value that is returned by the stored procedure. It seems the examples return a value of 0 or 1. How can I call the stored procedure with it's three paramaters and return the varchar value that is returned when the stored procedure is ran into a variable? I thought using the executescalar method would accomplish this but it does not seem to be working. Does anyone have any sample code I can look at? Please advise.