Msg 102, Level 15, State 1, Line 3Incorrect syntax near 's'.Msg 105, Level 15, State 1, Line 3Unclosed quotation mark after the character string ') Somehow the app is allowing the data to get in there... Thanks!

This syntax works fine to create the table, insert the data, and delete it... but will not work against my actual db field/data. Syntax I used and errors above were copied. Maybe there's somekind of constraint on the db that I'm not aware of. Fwiw, I had asked the software vendor's developers to delete similar data some time ago, and they were not able to. Thanks for trying to help!

damcguire (1/31/2014)This syntax works fine to create the table, insert the data, and delete it... but will not work against my actual db field/data. Syntax I used and errors above were copied. Maybe there's somekind of constraint on the db that I'm not aware of. Fwiw, I had asked the software vendor's developers to delete similar data some time ago, and they were not able to. Thanks for trying to help!

So post the ddl to create your table. Since we don't know your datatypes we are guessing.