query errors

[gtamir]

Hi,

I have errors in the table. I know that there is an "*" in phone column.

Why there is no error query? Why the error is displayed on all the columns?

Thanks Giora

[Greg_Deckler]

I would just replace your * with blank (null) value.

[gtamir]

Yes this is what I would normaly do. But there are other characters spred out there and I don't know where.

Why there is no query error? And why the word error is on all the fields.

[gtamir]

By the way, I don't load this table(YarpaCustomers) to the model because I want to append another file to it.

Is this the reason I don't get query error? If yes what to do to clean the table?