I've a Table called Employee where Grade column has value as given below.
I would like to implement below logic:
Get All characters before the comma(U#@H)
Search each and every character one by one in the string after comma (UMS)
If the character is found then delete it (U should be removed)
and the Expected output is U#@H,MS
Like above logic I would like to perform all the value in the column.
How to achieve this? Please do assist.