>Thanks. I am amazed that every time I pose a question, I learn something new! In your code, does the "replace" command actually find each of the 120 "lnMonth" field & records? Thanks again!
Yup, but don't do it for "heavy" processing on each record of large tables.
IF you have to denormalize this way, use arrays, or take the time to create
"handcrafted" replaces for multiple fields in 1 program line if this calculation really is the bottleneck.
HTH
thomas
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only