replace statment not replacing 1

[nathanharcup]

Hi All,
I am attempting to replace a statment in a varchar 2048 feild, I am using the below statment;

SELECT REPLACE (NOTETEXT,'internalID="CUSTOMER_NAME" attributeID="CUSTOMER_NAME" attributeType="String" attributeName="Client Name"', 'internalID="Name" attributeID="Name" attributeType="String" attributeName=""')
FROM CFG
WHERE NOTETEXT LIKE '%ALL change requests%'

The output in Query Analyzer shows it was succesfull, however when I run;

SELECT * FROM CFG
WHERE NOTETEXT LIKE '%ALL change requests%'

I find that it has not really changed the data.

Can anyone help?

Thanks
Nathan

 

[JamesLean]

Your statement is only SELECTing the replaced data. If you actually want to permanently update the data you need to use:

UPDATE CFG
SET NOTETEXT = REPLACE (NOTETEXT,'internalID="CUSTOMER_NAME" attributeID="CUSTOMER_NAME" attributeType="String" attributeName="Client Name"', 'internalID="Name" attributeID="Name" attributeType="String" attributeName=""')
WHERE NOTETEXT LIKE '%ALL change requests%'

--James

 

[nathanharcup]

Thanks James, that worked