Use Return statement in Stored Procedure

We can use return statement in stored procedure though it will not return any so called value . Return statement will cause to stop execution of the stored procedure and will return the control to the application from where the SP was called.