apostophe marks in sql query.

Results 1 to 2 of 2

Thread: apostophe marks in sql query.

  1. #1
    Join Date
    Dec 1969

    Default apostophe marks in sql query.

    I am trying to pull a name field from a datebase and use that as part of a query. However, some of the names contain an apostrophe mark "&#039;" in them. For example, if the name O&#039;Brien is pulled and used as part of a query it returns an error. How do I overcome this problem?<BR>Thanks in advance!<BR>Kiran.

  2. #2
    Join Date
    Dec 1969

    Default This is funny!

    You are even using the same example as is used in the ASPFAQs entry on this topic!<BR><BR>Just for that, I won&#039;t even make you search for the right FAQ. I&#039;ll point you right to it:<BR><BR>http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=27<BR><BR>Heck, you could have found the answer to this one by searching the ASPFAQs for "O&#039;Brien"!!!<BR><BR>For next time... The link to the ASPFAQs is at the top right corner of most every page on this site, including this one.<BR><BR>

Posting Permissions

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