> :: the message doesn't specify whether the value was a string
> :: or a number may suggest how completely the SQL context is
> :: lost when the error is detected.
>
> And they cant be caught any higher up?

Why not make it part of the input validation rather than relying on the db?

Rgds

Si Carter
TECT Software Ltd
http://www.tectsoft.net/