sqlserver 数据类型转换报错

IF @ldPropertyValue =''

 BEGIN
       IF EXISTS( SELECT 1 FROM dbo.table1 WHERE DataType IN('decimal','int') AND PropertyItemNo = @ldColumnName)
BEGIN
SET @ldPropertyValue ='0'
END

END