How do I update a substring within a string??

[kre1973]

Basically, I have the following SQL that I need to modify so I can update a substring in the "JobFailInstrTxt" table in my database:

SELECT JobNam, JobFailInstrTxt
FROM SchedUNIXJob, ApplicationCdeVal
WHERE ApplicationCdeVal.ApplicationTxt = "ebisrpt"
AND SchedUNIXJob.ApplicationCde = ApplicationCdeVal.ApplicationCde
GROUP BY SchedUNIXJob.JobNam

Basically, the output of above SQL produces the following output:

Columns "JobNam" "JobFailInstrTxt"
ebisrptClientArchExtrDates Wait 5 minutes and restart job. Retry 3 times then contact support next morning via EBIS cell(312-662-4811).
ebisrptClientSybStdAlnLoad Wait 5 minutes and restart job. Retry 3 times then contact support next morning via EBIS cell(312-662-4811).
ebisrptConMgmtSABox Wait 5 minutes and restart job. Retry 3 times then contact support next morning. If no answer via phone Call EBIS cell(312-662-4811).
ebisrptFieldComplete Wait 5 minutes and restart job. Retry 3 times then contact support next morning. If no answer via phone Call EBIS cell(312-662-4811).
ebisrptFieldInit Wait 5 minutes and restart job. Retry 3 times then contact support next morning via EBIS cell(312-662-4811).




The desired output would look like this:

Columns "JobNam" "JobFailInstrTxt"
ebisrptClientArchExtrDates Wait 5 minutes and restart job. Retry 3 times then contact support IMMEDIATELY via EBIS cell(312-662-4811).
ebisrptClientSybStdAlnLoad Wait 5 minutes and restart job. Retry 3 times then contact support IMMEDIATELY via EBIS cell(312-662-4811).
ebisrptConMgmtSABox Wait 5 minutes and restart job. Retry 3 times then contact support IMMEDIATELY. If no answer via phone Call EBIS cell(312-662-4811).
ebisrptFieldComplete Wait 5 minutes and restart job. Retry 3 times then contact support IMMEDIATELY. If no answer via phone Call EBIS cell(312-662-4811).
ebisrptFieldInit Wait 5 minutes and restart job. Retry 3 times then contact support IMMEDIATELY via EBIS cell(312-662-4811).


So, what I need is to replace the substring "next morning" with "IMMEDIATELY" in the JobFailInstrTxt table.

Also, I need the word "IMMEDIATELY" in caps if that's possible.

Thanks