Divide by zero error in stored procedure

Question

Hi i executed the following stored procedure in .net web application. Then run the application. I got this error

" Divide By zero error "

Stored procedure:

CREATE procedure Details(@Stringtext varchar(8000),@SearchStringtext varchar(100))
as begin
SELECT ({fn LENGTH(@Stringtext)}-
{fn LENGTH({fn REPLACE(@Stringtext, @SearchStringtext, '')})})/
{ fn LENGTH(@SearchStringtext)}AS String_Count

end

comments are all welcome

thanks suresh

Answer 1

Evidently:

{ fn LENGTH(@SearchStringtext)}

... is evaluating to zero.

Answer 2

It seems that the length of SearchStringtext is 0 -- so the procedure tries to divide by zero.

Answer 3

If SearchStringtext is empty, the length of it becomes 0. Thus the stored procedure tries to divide by zero (which is an undefined thing to do).

In other words the following part becomes zero:

{ fn LENGTH(@SearchStringtext)}

You might want to add some logic (if statement perhaps) to prevent the division to happen if the SearchStringtext is empty.

Answer 4

The length of the SearchStringText is Zero and hence there is divide by zero error. Make sure that when the function is called, the string is of non-zero length. Alternatively check for length before doing the select

Answer 5

{ fn LENGTH(@SearchStringtext)}

is evaluating to 0.

However, why is this a stored procedure? You are not using any db feature? Unless this is a simplified problem , all this (length, replace etc) could be done in your .net application

Answer 6

The only division operation in this procedure, has fn LENGTH(@SearchStringtext) as the divisor.

Hence it seems that length of **SearchStringtext** is evaluating to zero. It might be possible that you are trying to search an Empty string.

Please check and then elaborate the question details, along with the DB platform.