I have always used the RETURN code to return a number that indicates a status, it doesn't always indicate an error per say but a status of execution.

One example is that we have a stored procedure that allows you to search on an institution name. If there are more than one name that match the like search done on the name you enter then the SP delivers a list of all matching names with their ID's. If only one name matches then you get your search result. We return a code to tell our web site if it is getting the results or a list of institutions. Depending on the return code the web site will display a drop down with all the institutions that matched your search or your results.

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital markets contact database and software platform.