[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.
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
Roger Bjärevall
said
almost 12 years ago
[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
anonymous