Results 1 to 3 of 3

Thread: How to escape ampersand while selecting or inserting data?

  1. 12-10-2003, 02:55 AM #1
    m_nekkanti
    m_nekkanti is offline Registered User
    Join Date
    Dec 2003
    Location
    India
    Posts
    2

    How to escape ampersand while selecting or inserting data?

    How to escape ampersand while selecting or inserting data?
    I know that for single quote we have to use two single quotes.
    Thanks
    m_nekkanti
    Reply With Quote Reply With Quote
  2. 12-10-2003, 07:00 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    please post an example.

    You can use replace to remove &
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 12-15-2003, 08:17 PM #3
    Karen_ivy
    Karen_ivy is offline Registered User
    Join Date
    Dec 2003
    Posts
    1
    Hi,

    If I understand well what you're asking, you want to have a descriptive text with & in it? Then, you just have to enclose it in single quotes like '&'.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules