By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| REPLACE(REPLACE('ABC@YAHOO.COM;EFG@YAHOO.COM;HIJ@YAHOO.COM;AB1@YAHOO.COM','HIJ@YAHOO.COM',''),';;',';') |
|---|
| abc@yahoo.com;efg@yahoo.com;ab1@yahoo.com |
| REPLACE(REPLACE('ABC@YAHOO.COM;EFG@YAHOO.COM;HIJ@YAHOO.COM;AB1@YAHOO.COM','HIJ@YAHOO.COM',''),';;',';') |
|---|
| abc@yahoo.com;efg@yahoo.com;ab1@yahoo.com |