Is there any way to REPLACE a part of a field in Netcool Omnibus using a single SQL query?
Eg: If a field, say Name = 'Hello this is an example' and I want to replace it with Name = 'Hello this is not an example'; ie I want to replace 'is an' --> 'is not an'. Can this be done using an SQL query?
I tried: SELECT REPLACE(Identifier,'is an','is not an') FROM TABLE; but this did not work. It seems there is no such function as REPLACE.
How can this be done?