• However you are calling the function, you put error-handling in there.

    For example, if you have a function that select the first employee ID in a department, you might have a proc that selects all departments, and then uses the function. You would use Try/Catch in that proc.

    I really can't give you step-by-step instructions or actual code, without knowing how you are using the function.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon