Search, Replace and Duplicate Utility

This tool is useful to generate a series of SQL statements based on a model statement. By default we use @@@ as substitution variable.

Enter a model statement used for substitutions SELECT * FROM MYLIB@@@/MYCUST WHERE OVER120 <> 0 AND ACTIVE = 'Y' AND CPY = @@@ UNION
Enter Value to search for @@@
Enter a comma delimited list of values that you want to substitute 001,002,003,004,005,006,007,009,010,020,051,052,053,054,055,073,103,107,108,121,181,191

Substitute & Duplicate! Validate SQL Run SQL Copy to Clipboard