Hi SQL Gurus!

Just wanted to know how I can trap errors in a stored procedure? Like if a value was entered more than once on a primary key field, how do I trap the error? To inform the application of the error I would just return an error number.


Thanx! in advance 8 )

Martin