Crude but quick way of doing this is to copy then run the outcome of a query like the below:
select 'update ' + table_name +
'set ' + column_name + ' = NULL
where ISNUMERIC(' + column_name + ') = 1 AND cast(' + column_name + ' as int) < 0'
from INFORMATION_SCHEMA.COLUMNS
where DATA_TYPE = 'varchar'
arrghhh I LOVE these views I don't know why MS is getting riod off them! :crazy:
Actually this will probably not work with columns that have mixed data as the cast would fail. hmmmm
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn