Cannot use a BREAK statement outside the scope of a WHILE statement. Incorrect syntax near the keyword ‘with’. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicoln. Incorrect syntax near ‘Word’.
tsqldata = tsqldata.Replace("'", "");
… so that the string value was inserted into SQL Server. That eliminated the problems. One thing to note (especially before we’ve had caffeine) is that Twitter readers or Web Page readers may catch apostrophes and eliminating them works as one possible solution.