Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2002
    Location
    India
    Posts
    40

    Unanswered: Help me on Single Quote Probs

    hi all,

    I have table as below

    Test1(table name)
    ID Varchar
    Desc Varchar

    Data

    ID Desc
    12 URgood
    13 That's good
    14' That is Good

    Now i want to get only the record 14' ...not other record...so can any one help me on this..

    bye
    Suryadevara

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Help me on Single Quote Probs

    select * from test1 where id = '14''';

    The trick is to double up any quotes within the text string.

  3. #3
    Join Date
    Jun 2002
    Location
    India
    Posts
    40
    Sorry i dont want to give the ID ......using LIKE ....
    Suryadevara

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Same applies, double up the quotes:

    where desc like 'That''s%'

Posting Permissions

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