Replace substring in SQL

[remex74]

How can I change substring in a field with SQL commands?

I tried this:
UPDATE "xxx.dbf" SET field1 = REPLACE(field1, "FROMTHIS", "TOTHAT") where field1 like "%xy%"

I got this Error Message:
-> File 'replace.prg' does not exist

Thank you.

[Admin]

Hi there,
use the STRTRAN() function:

Code: Select all

UPDATE xxx SET field1=STRTRAN(field1, 'FROMTHIS', 'TOTHAT') WHERE field1 LIKE '%xy%'