Special character in concatenated sql script causing error <p>I save stored procedure code as files and then execute them in several different databases. I am trying to concatenate multiple files (100's). Every utility I use seems to create some special characters in the file that cause an error when i execute the script in sql.</p> <p>Currently, i used</p> <pre><code>type *.sql &gt; script.sql </code></pre> <p>in DOS. I am getting the following error in many places.</p> <pre><code>Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ''. </code></pre> <p>How can I find this character so I can do a find/replace? Thanks!</p>