select @isOK = convert(smallint,isnull(isSet,"0"))

Hi...

I have a NULL value there and i get this error.

isSET is null by the way.
Also isSET value is String in my Java class and it is assigned null at first.


Syntax error during explicit conversion of VARCHAR value 'null' to a SMALLINT field.

What may be the error?

Does not it set the isSet value to "0" and then this varchar "0" value to a smallint?

You are trying to convert the string zero to an integer. If you use select @isOK = convert(smallint,isnull(isSet,0)) it would be okay.

Thanks. I changed "null" values to null.

You were passing isSet as "NULL" not as NULL.That was the issue.Thanks,