Knowledgebase

Knowledgebase ID# :: 3129

Simple SQL Replace Statement Syntax

subject: code example

product: SQL version:

The following SQL statement can be used as an example to create a replace statement. Useful in Collage using the CTRL+SHIFT+ALT+F12 window.

UPDATE table_name SET column_name1 = REPLACE(column_name1, 'value1','value2');

related information:

If using Serena Collage, remember to set the following configuration in the nas.properties file:

NASServlet.SVlevel=debug