Getting tricky with adding text

[TVining]

I need to add "FOR IMMEDIATE RELEASE." to all of my records.

I know I can use ConCat, but approximately 75% of my records contain some HTML at the beginning for formatting. I need to add the statement to the Beginning of the text (after </DEV>) or at the beginning of the record, whichever is closer.

So, a record without HMTL will be:
"FOR IMMEDIATE RELEASE.
Private John G dough has graduated......"

And with will be:
"<PHOTO>
FOR IMMEDIATE RELEASE.
Private Gina I Jane has graduated......"

Is there an easy way to say "look for </DEV>" and if not, do it anyways?

The reason is this: I later pull my title from everything after "RELEASE. " and before "HAS GRADUATED"

Thanks!
Tony

[amitpatel66]

I need to add "FOR IMMEDIATE RELEASE." to all of my records.

I know I can use ConCat, but approximately 75% of my records contain some HTML at the beginning for formatting. I need to add the statement to the Beginning of the text (after </DEV>) or at the beginning of the record, whichever is closer.

So, a record without HMTL will be:
"FOR IMMEDIATE RELEASE.
Private John G dough has graduated......"

And with will be:
"<PHOTO>
FOR IMMEDIATE RELEASE.
Private Gina I Jane has graduated......"

Is there an easy way to say "look for </DEV>" and if not, do it anyways?

The reason is this: I later pull my title from everything after "RELEASE. " and before "HAS GRADUATED"

Thanks!
Tony

But in your sample data, you show it as after <PHOTO>?

You want the text to be inserted after <PHOTO> or after </DEV>?

[TVining]

But in your sample data, you show it as after <PHOTO>?

You want the text to be inserted after <PHOTO> or after </DEV>?

</DEV>

sorry. I was using that as an example. <photo> meant that is where the photo appears when the record is displayed.

Tony

[amitpatel66]

</DEV>

sorry. I was using that as an example. <photo> meant that is where the photo appears when the record is displayed.

Tony

I will suggest you to use two different updates as shown below:

 
UPDATE table1 SET column1 = CONCAT('FOR IMMEDIATE RELEASE',column1) WHERE INSTR(column1, '</Dev>') = 0
/
 
UPDATE table1 SET column1 = CONCAT(SUBSTRING(column1,1,INSTR(column1,'</DEV>') + 6),' FOR IMMEDIATE RELEASE ',SUBSTRING(column1,INSTR(column1,'</DEV>') + 6)) WHERE INSTR(column1,'</DEV>') > 0
/
 
 

[TVining]

Okay, I get it. Thanks!!