Is not Null problem because of ""

[Guest]

Hi

When I do a search on my fax field and input is not null it doesn't show
anything up because there is a "" in the field which shows as blank. It
hasn't got the zero length property set but was imported from Excel.

How can I delete the "" from the fax field - it doesn't seem to let me.

Pls help.

Anita

 

[Wolfgang Enzinger]

Hi Anita,

How can I delete the "" from the fax field -

you could "clean" your table like this:

UPDATE yourtable SET fax=NULL WHERE LEN(fax)=0;

HTH,
Wolfgang