Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    54

    Unanswered: SQL and Single Cot

    How to insert a single cot in a SQL update :

    example :

    update mytable
    set val='please don't go'

    I beleive, I need to replace the ' of "don't" ?
    how ? by what ?

    Thanks.
    Pierre.
    Pierre (Pl-Arts)

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    set val='please don''t go'

    two single quotes in a row for each one inside the text


    rudy
    http://r937.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •