Hi, |I have several hundred SQL queries that need to be modified by removing a certain part of the WHERE Clause I want to remove this string: `AND CHARINDEX([DL_LiquidityBandMat],'%;')>0` where % could be A3, A4, A5, AA, AB etc what's the best way to do that please? It's a one off task thanks for any help Philip
Hopefully you have all the queries already in source control or somewhere outside of the database. If not you will need to do that first. After that you have several options. - SQL Server Management Studio, open the files and Search/Replace. - Powershell script to look at all the files in a directory and replace the string characters. - Third Party Software to search and replace. Any way you go there is going to be some work involved.