Deleting records from table depending on field length 2

[Crackpot21]

I am trying to delete all the records from a table based on the length of the client name.

I have tried the following, but with no success.

DELETE ALL FOR LEN(Client) = 2

Any help would be appreciated.

 

[Imaginecorp]

try
delete for len(alltrim(client)) = 2 all

 

[Imaginecorp]

sorry dont need all, the For will delete all records matching the 2 length

 

[Mike Lewis]

You need to do this:

DELETE ALL FOR LEN(ALLTRIM(Client)) = 2

Without the ALLTRIM(), the length will always be that of the field itself, not any particular client.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[Imaginecorp]

Thank you; glad I could help.

 

[Mike Lewis]

Ditto.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business