> I do not know why you are always asking for ESCAPE. > ESCAPE is ONLY known together with a LIKE-predicate. > And there you have to specify the escape-character you want.
In SAP DB, that is so. I am not asking for ESCAPE keyword, I'm asking for equivalent of "escape character", something that exists in Informix, Oracle, DB/2, not to mention Perl, Java, C/C++, shell scripting, etc. Think about is a a REGEX and "regular expression". If you had a keyword in SAP DB called REGEX, I'm not asking about it... For instance, when you write 'Who''s Online' in SAP DB, you are actually using the first single quote to "escape" the special significance of the second single quote. If you do not "escape" this special significance, it would mean "end of string". > For string_literals (those things holding values for character columns) > which are enclosed by single quote is written in the manual: > http://www.sapdb.org/htmhelp/64/e90daaa60f11d2a97100a0c9449261/frameset.htm > it is said > An apostrophe within a character string is represented by two successive apostrophes. > > double quotes do not have a special meaning in string_literals. > They are used for special identifier. (see manual) And if you want to use an >indentifier > with a double quote in it, use two successive double quotes. OK, so the answer is: Single quote should be escaped with another single quote. Double quote should be escaped with another double quote. Other characters have no special meaning in SAP DB, so they don't need to be escaped in context of the string literal. Correct? Thanks, -- Yours, Andrej Falout, http://www.falout.com/disclaimer.html Visit the OpenSource alternative, Aubit 4gl: http://aubit4gl.sourceforge.net PLEASE NOTE: All HTML email sent to me WILL BE DELETED AUTOMATICALLY WITHOUT READING. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
