• 1 reply
  • Latest Post - ‏2013-07-26T16:24:23Z by User_Technologies_and_Delivery
3 Posts

Pinned topic Replace function in SQL queries to Omnibus

‏2013-07-04T13:39:41Z | nco_sql omnibus replace


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?