Hey guys, I imported pricing into my table and some were a NULL (empty) value and when I try to update them to '0.0000' I get the following 'Error converting data type varchar to numeric.'
Select * from MyTable
Where Price = ''
also returns the error 'Error converting data type varchar to numeric.'
Is there any way I can update the db, or will I need to change my master import file not to contain null values?