Update one character in a string
572055May 26 2009 — edited May 26 2009Hello Experts,
I would like to update a character in a string in a column using update statment.
For eg in table a1 column has "ABCDEF", I would like change "C" with "c" . After change the a1 value should be "ABcDEF".
Any help will be highly appreciated.
Regards,
Rashida