It is apparently my week for goofy questions.
A user enters "State Farm Insurance" into the Opt. Address field (street2 in t_address) and after the record is saved, it is auto-corrected to "State FaRoom Insurance".
I know there is a stored procedure somewhere that controls the specific corrections and is triggered anytime there are changes made on the constituent's record. About a year a go I had to modify it so that "Ste." was changed to "Suite" instead of "Streete". But the intervening months have erased the name of the procedure from my memory. Searching for Address Correction on the site doesn't give me anything.
Does anyone know where the procedure is located?
If you are using Brian Wilbur Grundstrom's report it is a function, LF_TITLECASE.I Believe that is where you update it.
Also if you need more information it is solution 99 in reference materials on TASK online.
Thanks Ryan! That was it exactly.
Ok, no more odd questions this week, I promise. I'll even try to contribute something useful to some other threads.
So glad I have this forum to bounce things off of. I'd drive myself crazy otherwise.