Is not Null problem because of ""

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi Anita,
How can I delete the "" from the fax field -
Click to expand...

you could "clean" your table like this:

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

HTH,
Wolfgang
 
Back
Top