Divide by zero error in stored procedure?

Evidently: { fn LENGTH(@SearchStringtext)} is evaluating to zero.

Evidently: { fn LENGTH(@SearchStringtext)} ... is evaluating to zero.

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.

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

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.

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.

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

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.