replace ' with space

[Former Member]

Does anybody know how to replace an ' with space.

I need the word 'Jon' to be converted into Jon .

Thanx

[Former Member]

Hello

REPLACE '''' WITH space INTO field. 

[Former Member]

Hi,

Did you mean something like

REPLACE ',' IN W_DATA WITH SPACE.

?

[Former Member]

Hi,

We can do like this also.

replace `'` in myvar with ''.

we can use tilde character / key. it is found on keyboard to the left of '1' key.

regards,

amit m.

[former_member778253]

yes. the one whch Amit had suggested is the right one.

You can try.

[VivekG]

Please use the syntax : REPLACE ',' IN W_DATA WITH SPACE.

Vivek Gupta

[Former Member]

Yes, it is useful to using ` character in string operations. You can use `'` easily as an alternative.