• Thanks Jeff Moden.

    yes, you are correct, Select 1/0 will raise the error (Msg 8134, Level 16, State 1 - Divide by zero error encountered.)

    But is that possible to change the error message as per our wish?