Re: SQL: find pattern and replace with blanks

Time to hit the SQL guru well again. ;-)

I have a name field that has, as an example, "DOE, JOHN A 12/AL/PMZ
"

The "12/AL/PMZ" will always occur after the name (can't guarantee the
number
of spaces separating the two), and will always follow the pattern
"nn/AA/AAA", where "nn" is a 2-digit number, and "AA/AAA" is always
upper-cased alpha. When and if such a pattern is found, I need to replace
it with blanks. The way I would search for this would use:
LIKE '% __/__/___%'
Even though the underscores represent any single character, I can't

I would ever find it in a real name in my data. But even if I use this,
how
would I then replace the string with blanks?

FWIW, this is on V5R4.

TIA,
Dan
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.9/1419 - Release Date: 7-5-2008
7:46