View Incident Report

Serious

Reported By: Ole Willy Tuv
Reported On: 10/1/2002
For: Version 3.17 Build 1

# 1234 Trying to Use the SQL REPLACE Function With a Data Column Does Not Work

The following test script returns 'FreddyMan' as Fld1 value, while my intention was 'FreddyTHEMan'.

DROP TABLE IF EXISTS MEMORY Test;
CREATE TABLE MEMORY Test(
Fld1 CHAR(20),
Fld2 CHAR(3)
);

INSERT INTO MEMORY Test VALUES('FreddyTheMan', 'THE');

UPDATE MEMORY Test SET Fld1=REPLACE('The' WITH Fld2 IN Fld1);

Resolution

Fixed Problem on 10/2/2002 in version 3.18 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap