General information
Forum:
Microsoft SQL Server
>Thanks a mil. I'll check it out pronto.
>
>By the way do you know how i can include strings which contains an apostrophe ???
>
> eg. Christopher's Egg. The apostrophe would normally give an error. I wrote a routine to remove them automatically when typed in the text box. The ideal situation would be to include those apostrophe.
Do you mean something like this:
«
When QUOTED_IDENTIFIER is OFF, SQL Server follows these rules for the use of double and single quotation marks:
Quotation marks cannot be used to delimit identifiers. Instead, use brackets as delimiters.
Either single or double quotation marks can be used to enclose character strings.
If double quotation marks are used, embedded single quotation marks do not have to be denoted by two single quotation marks:
SELECT * FROM [My Table]
WHERE [Last Name] = "O'Brien"
»
I took this from Books OnLine
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only