how do I Update a search result to be Proper fmt?

[J__]

Hi,

I'm not sure this is the right place to ask. Please let me know if there is a preferred forum for this question.

I would like to find a list of records from a table and the last_name field I would like to apply the Proper function to. The Proper function changes text from FRED to Fred

is there a script around which does this?

I figure I have to go through each record and then some how say

Set field [ myTable::Last_Name, Proper( myTable::Last_Name) ]

the thing is I don't think this Proper() function can be called unless it's part of calculation right?

thanks for any tips in advance,

Sincerelry,

J__

[-Queue-]

You would either run a loop,

Go to Record/Request/Page [First]

Loop

Set Field [thistable::Last_Name; Proper(thistable::Last_Name)]

Go to Record/Request/Page [Next; Exit after last]

End Loop

or run a Replace Field Contents with the same calculation.

Either way, Proper is part of the calculation result.

[J__]

Thanks Queue.

I was wondering whether there was any other way to do it. But Loop is fine.

thanks,

Sincerely,

J__