If there is another way to do this, I'd be happy to know.
What I really want is for anything that's supposed to be a number but is a string, it should have an attempted cast, but if the cast fails, then fail to validate and provide a message as mentioned before.
Based on your documentation it could just be doing exactly as described:
However I don't see how it's useful to cast everything to 0 when casting fails.
I'd rather it something like "{type1} required, could not convert given {type2} value to {type1}."
What's the logic behind casting everything to 0 on failure?
I'm replacing the pragma cast to this for now:
If there is another way to do this, I'd be happy to know.
What I really want is for anything that's supposed to be a number but is a string, it should have an attempted cast, but if the cast fails, then fail to validate and provide a message as mentioned before.
Thank you for listening. Keep up the good work.