All,

I need help with search and replace

Ex:
I have like below
CREATE TABLE TEST
(SNO INTEGER)
IN USERSPACE1 @

I want to replace @ at end with COMPRESS YES@
CREATE TABLE TEST
(SNO INTEGER)
IN USERSPACE1 COMPRESS YES@

Any help is really appreciated