|
|
Posted by Roy Harvey on 10/22/06 21:54
On 22 Oct 2006 05:12:00 -0700, "--CELKO--" <jcelko212@earthlink.net>
wrote:
>Nesting the function calls is better because it gets done with ONE
>update statement instead several.
That may very well prove to be an important advantage.
On the other hand, if you accept replacing them one at a time you
could put the characters to be replaced in a table. An advantage to
that would be that adding or subtracting from the set of characters
would be a simple INSERT or DELETE transaction. When nesting changes
to the list requires coding changes.
So, as so often is the case, It Depends.
Roy Harvey
Beacon Falls, CT
Navigation:
[Reply to this message]
|