>>DECLARE @test varchar(20)
>>SET @Test = '0'
>>
>>SELECT 1 + @Test
>>
>>SET @Test = '0.0'
>>SELECT 1 + @Test --BOOOOOOM
>>
>
>Thanks Borislav,
>
>Those were my thoughts too. I was just trying to decide if I should go through all 600+ SPs looking for implicit conversions, or fix them as I encounter them. I think I'll just fix them when I run into them.
O!
Yes, IF SPs run as they expected you can fix them one by one.
But you never be sure what MS will change in next SP (I doubt that will change the implicit conversion, but...) :-)Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.