Wednesday, July 22, 2009

sql string replace

this is an example of the sql string replace function

update tableName set
columnName = REPLACE(columnName, substr(columnName, 8, 7),'newStringValue');

No comments: