Single quote
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Single quote

  1. #1
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455

    Single quote

    I have a table product, which has column name product_name

    Product Name columns has values
    34 LAND'S
    64 LAND'S
    121 PORT'S
    etc

    I need to qualify my where cluse to match exactly product_name, I cannot use like command

    How do I do that to put " ' " in my cluse

    expamle:
    select * from product
    where product_name = '64 LAND'S';
    above query will return error quoted string not properly terminated.

    Thanks in Advance.

  2. #2
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    I got it, thanks

Posting Permissions

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



Click Here to Expand Forum to Full Width