Diff Between Function and Stored Procedure

A FUNCTION is always returns a value using the return statement.
A PROCEDURE may return one or more values through parameters or may not return at all.

A Function can be used in the Sql Queries.
A PROCEDURE cannot be used