Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-08-30 : 06:16:29
|
| shailesh writes "I have to insert a "insert query" (insert into.....) from VB to MS SQL . This throws an error when I try to insert a query statement with single quotation marks . I dont want the quotation marks removed as I want the statement to be stored as it is. " |
|
|
gpl
Posting Yak Master
195 Posts |
Posted - 2004-08-30 : 07:28:19
|
| You need to double the quotes in your stringeg REPLACE(MyString,'''','''''')Graham |
 |
|
|
|
|
|
Inserting single quotation marks