clean up the table.
Posted on 2008-06-19
The table is populated the data and one of the field is Varchar and it represents some integer values.
so with in the sql query i need to compare the field value with an integer.
but unfortunately the data is bit currepted and the field has some #### in it and the sql is working fine if i delete those rows.
The other table has the same problem but it has hundrends of such rows.
how to delete the rows - whose column value is not capable of casting it to integer. ?