471,083 Members | 1,183 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,083 software developers and data experts.

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

Jul 19 '05 #1
2 8863

Try this:

TMDESCRIPTION = '26g Galvalum Wide - Flat Sheet''s'

(use two single quotes together).

:D
--
Posted via http://dbforums.com
Jul 19 '05 #2
LKBrwn_DBA wrote:
Try this:

TMDESCRIPTION = '26g Galvalum Wide - Flat Sheet''s'

(use two single quotes together).

:D
--
Posted via http://dbforums.com

I have tried it, and it still does not work.

After posting I realized that it's a bad example. Sheet's would never
be used, but everyone should get the point.

I have tried the /, using '' or ''', and it all does not work.

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by N U | last post: by
2 posts views Thread by junky_fellow | last post: by
4 posts views Thread by Guadala Harry | last post: by
2 posts views Thread by Christopher Ireland | last post: by
15 posts views Thread by pkaeowic | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.