Post reply

Insert with ' Symbol

  • July 4, 2013 at 3:31 am

    #296057

    Hi Team.

    Insert into table_Name values (1,'Text') -- Done.

    Insert into table_Name values (2,'Text's') - -- Unclosed quotation mark after the character string ')

    How to insert a value with ' Symbol.

    Please help..

  • July 4, 2013 at 3:42 am

    #1629780

    In order to have a string with an apostrophe, you need to use two apostrophes together, eg

    Insert into table_Name values (2,'Text''s')

    Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]

  • July 4, 2013 at 6:21 am

    #1629819

    Thank You 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

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