String length.

[skea]

I have a fax number field iwhich has a mask. +(000)-00-000-000 in a table of many records.
The problem is that every record has a number in the first part of country code +(001)which must have come there by mistakes, few records have complete and true fax numbers.

I need a query that can Update this Fax_Number field where the length of the string is less than 7 digits.
Some thing like UPDATE Contacts SET Contacts.Fax_Number = ""
WHERE ((Len("Fax_Number")>"6"));

How can i do this. Thanks.

 

[RuralGuy]

Use the Query Builder and make a Select query until it returns what you want.

hint: Criteria Len([Fax_Number]) > 6

 

[skea]

thats what i did. Actually Len([Fax_Number]) <7 but it ends up updating every record thus doesnt recognise the criteria.

 

[skea]

Fixed. Thanks.

 

[RuralGuy]

Care to share your fix with the rest of us so we can learn?