Re: SQL: find pattern and replace with blanks

["Raul A. Jager W." <raul@xxxxxxxxxx>]

Use "POS" to find the /

Dan wrote:

> 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 imagine
> 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
>