Andrej Falout wrote:

> In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says...
> > Andrej Falout wrote:
> > >>'Who''s Online'
> > > So, single quote is escape character?
> > 
> > No, it just works to insert single quotes.
> 
> And what exactly _IS_ escape character then? How do I insert 
> a double quote?
> 
> 'xxx"xxx'

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.

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.

Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to