When to use Stored Procedures

[Tompkins Neil]

Hi,

I've used mainly of the older versions of MySQL.  However am looking to port
a application across to MySQL 5.  My question is when would one decide to
use a Stored Procedure over a query written at the application level ?

Cheers
Neil