$ nco_sql -user netcool
1> update custom.filterclauses set sqlclause = 'EventClass = \'Tech Event\'' where clauseid = 26
2> go
(1 row affected)
This detail seems to be missing from the manual and is somewhat hard to find otherwise. Other variants like doubling ‘ or concatenating a char(39) function will not work.