Start a new topic

90.1866 - Replace with parentheses fails

[This topic is migrated from our old forums. The original author name has been removed]

Create a SQL query as follows: declare @a varchar(5) declare @b varchar(5) declare @c varchar(5) declare @d varchar(5) Now try and replace all *varchar(5)* with *char(5)*. Nothing happens. It appears to be the brackets in the search that cause the problem. 4 occurrences are found but none get replaced. If I remove the brackets from the search field all 4 get replaced.

[This reply is migrated from our old forums.]

Re: 90.1866 - Replace with parentheses fails
Hi Vince, Thanks for reporting this. We will look into a fix for it. In the meantime, you can use this work-around: + Open the Replace dialog, + Check the "Use" checkbox in the Options area, select Wildcards, and uncheck "Use" again + Click Find Best Regards, Hans
[This reply is migrated from our old forums.]

Re: 90.1866 - Replace with parentheses fails
Vince, Just to inform you that this is now fixed in the 9.0.1 version. Regards Roger