Problem with a database 1

[PremiumL]

I have a database called mail.dbf. I need to delete zip codes that end in an odd number (ex: 1,3,5,7 & 9). How do I only keep zip codes that end in an Even number. Keep in mind that the zip code field is called zip and is only 5 characters long.

Thanks for the help,

Jarrett

 

[DSummZZZ]

You could do something like this:

DELETE ALL FOR MOD(VAL(RIGHT(zip, 1))) > 0

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[PremiumL]

Dave,

I did that and I got an error that says too few arguments. What should I do?

 

[DSummZZZ]

Woops, my bad. The MOD() function requires a second value.
This statement:

DELETE ALL FOR MOD(VAL(RIGHT(zip, 1))) > 0

should instead read:

DELETE ALL FOR MOD(VAL(RIGHT(zip, 1))[COLOR=red] ,2[/color]) > 0

As a side note, you are working with a backup of the table, aren't you?

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[tesar]

Jarrett,
not so scientific as Dave, simply as you say
dele all for right(zip,1) $ "13579"
Tesar

 

[NasibKalsi]

I would not mind adding

.and. len(alltrim(zip)) = 5


Nasib Kalsi