Instead of returning the value and raising error, I took the previous option i.e. converting into Stored procedures.

This took only less time for me to convert.

Thank you Guys, For your...

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...

Thanks Andras...

Since i don't have any idea about the application & how the functions were called from the application. I'll check with my client and update you soon.

By any chance,...