Escape sequence

I have a query I use to validate that there are no other records with the same descriptions - a table for items.

Now the querry ends up like this:

SELECT COUNT(ITMID)
AS COUNT
FROM
   TBLITEM
WHERE
   ITMDESCRIPTION = '26g Galvalum Wide - Flat Sheet's' AND
   ITMID != 707 Where the 707 refers to itself. But the Sheet's' will not work. Says "ORA-00933: SQL command not properly ended".

Can someone help me with this? is there a way to escape the '?

Thank you,
Mark Received on Tue Aug 26 2003 - 23:14:26 CEST