Hi

I hope someone can help with this.

I have a SQL server table that has a tiny int value field which can either accept 0 to 4. The field is also set to allow null values.

My problem is that one of my users has set information in this field for 120 rows, then realised that she should not have used this field at all. Now when I go into SQL Server to delete the results I get an error that says :

"The value you entered is not consistent with the data type or legnth of the column, or over grid buffer limit".

It will allow me to replace the numerical value she has set (1 to 4) with a 0, but will not allow me to delete the content. Many of the other rows display <NUL> in this field.

Thanks in advance for your help.

Hi there

Just update them to null in sql code, for example:


UPDATE table_1
SET ID = NULL

Hi there

Just update them to null in sql code, for example:


UPDATE table_1
SET ID = NULL
Thanks SQL, much obliged.

You are welcome :)