' in SQL command

Results 1 to 2 of 2

Thread: ' in SQL command

  1. #1
    Join Date
    Dec 1969

    Default ' in SQL command

    I am performing an UPDATE SQL command. some of my variables in the WHERE clause have &#039; in them<BR><BR>Ex:<BR><BR>Brian&#039;s<BR><BR>This causes an error when processing the SQL command because it sees the &#039; as the end of that string. how do i deal with this?<BR><BR>thanks

  2. #2
    Join Date
    Dec 1969

    Default read the FAQs

    this is about the most common newbie error, and is well covered in the FAQs

Posting Permissions

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