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 - 2001-04-13 : 08:35:03
|
Chris Hammond writes "With text values being surrounded by apostrophe's in the Values string of an SQL Insert statement, how is SQL supposed to handle a text value that contains an apostrophe itself?
INSERT INTO table(name,title,notes,company)
Values('chris','IT','that's the question','abc company')
Since many applications contain user input forms with note, comment, memo fields etc.. where users are describing or explaining their issue, it is natural for them to abbreviate many words. Since they use an apostrophe, SQL encounters a syntax error and then does not execute the command." |
|
|
|
|
|
SQL Insert Statements