Lo group,
I would like to know if it is possible to a (string) replace on
existing records based on a given pattern.
Let's say I have a table containing the following records (strings):
Windows/98
Windows/98/Registry
Windows/2000
Windows/2000/Registry
Is there an SQL method for scanning all records in the
table for the pattern "Windows/98" and then, when a match is made, replace
only the "Windows/98" part of the string with "Windows/2003"?
I am having a hard time figuring this out so any help would be
more than welcome.
SomeDude.