2 Replies Latest reply on May 3, 2006 2:15 PM by bigj99012

    Esscaping Charaters in ASP SQL statement

    bigj99012 Level 1
      I have a SQL statement that inserts a line of text that contains ( ' ) a single quote. How do i escape this so there server doesn't think it's the end of the string.

      SQLStr="UPDATE TABLE SET field = 'This is my string to insert. It's not working because of the single quote' WHERE Id=31"

      ASP/ACCESS

      Thanks
      Jeremy