Inserting Value problem

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

TriggerMe SSChampion Points: 11752 More actions · Answer 1

1 way is to SET QUOTED_IDENTIFIER OFF

and then you can use double quotes for string variables.

Example; "2','3','4"

Kindest Regards,

Ryk Neethling Old Hand Points: 380 More actions · Answer 2

Old Hand

Points: 380

July 11, 2004 at 10:20 pm

Thank you, that worked!

deepankarb SSC Journeyman Points: 75 More actions · Answer 3

One more way is to replace all single instance of "'" with "''" using replace function.

Kemp Davis Ten Centuries Points: 1067 More actions · Answer 4

Ten Centuries

Points: 1067

July 13, 2004 at 2:47 pm

You can also insert:

'2'',''3'',''4'

Cookies on SQLServerCentral