Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Location
    USA
    Posts
    115

    Unanswered: Concatenate single quote...

    Hi,
    I am trying to concatenate single quotation mark (ie- ' ) in the select query but not succeed.

    If I concatenate word India's, how should I have to write the select query..?

    Its just query I have not concern with any specific database.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1

    quote inside quotes

    Code:
    select a='India''s', b='India'+'''s'
    
    a       b       
    ------- ------- 
    India's India's
    
    (1 row(s) affected)

  3. #3
    Join Date
    Jan 2006
    Location
    USA
    Posts
    115
    Thanx buddy...

Posting Permissions

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