Find highest number in four fields and replace fifth 1

[keepingbusy]

Hi

I have four fields in table and each record can contain a different number. I want to try and replace the fifth field with the highest number from the four fields. e.g.

Field names:

numb1 = 25
numb2 = 37
numb3 = 21
numb4 = 16

I would want numb5 to be replaced with numb2 (37) or whatever field contains the highest number which changes from record to record.

Searched the forum guys, there are some posts but cant find anything like this.

I'm sure there is a simple solution or command, your guidance is appreciated as always.

This version: VFP6

Lee

 

[jimstarr]

REPLACE numb5 with MAX(numb1, numb2, numb3, numb4)


Jim

 

[Imaginecorp]

Ditto:

With an ALL at the end if all Field5's are to be replaced... Quick and fast..

 

[keepingbusy]

Thanks Jim, worthy of a star for the fast response and resolution!

Imaginecorp: Thanks as well for your post and backup comment.

Lee

 

[keepingbusy]

Thanks Mike
Lee