Escape sequence for character apostrophe

[Former Member]

Hi,

I want to have character apostrophe in a character data type variable. How can we do this??? Is there any escape sequence for character apostrophe???

Regards,

Niranjan

[Former Member]

Hi,

I want to have character apostrophe in a character data type variable. How can we do this??? Is there any escape sequence for character apostrophe???

Regards,

Niranjan

[former_member435013]

Hi,

DATA:

apostr TYPE c VALUE ''''.

P.S.: Escape is apostrophe itself!

regards

Walter Habich

Edited by: Walter Habich on Jun 3, 2008 11:17 AM

[Former Member]

Hi, I cant get this question. CAn you please explain me ?

[Former Member]

Hey,

Even i am facing the problem of escaping a apostrophe . Can you please provide a solution?

Thanks & Regards,

Lata

[Former Member]

Hey,

Just check out the solution I'm using down below

[Former Member]

Hey,

Just check out the solution I'm using down below

[Former Member]

Hi.

To escape an apostrophe, just put an additional apostrophe.

Example:

WRITE / 'THIS LINE HAS AN APOSTROPHE '' IN IT!'.

Output

THIS LINE HAS AN APOSTROPHE ' IN IT!

[Former Member]

Hi ,

Use | | instead. like below.

DATA(lv_new_searchstring) = |*002*|.

DATA(l_stmt) = |SELECT * | &&
|FROM factory | &&
|WHERE upper(factory_name) LIKE '{ lv_new_searchstring }' | &&
|OR upper(factory_id) LIKE '{ lv_new_searchstring }'|.