Hi,
I want to replace multiple characters from a column in SQL. Below is the logic to replace.
| character | replace to |
| a | i |
| b | h |
| c | g |
| d | l |
| e | j |
| f | k |
| 1 | 9 |
| 2 | 7 |
| 3 | 8 |
| 4 | 6 |
| 5 | 0 |
| |
below is the example.
| Column | expected output |
| abc123 | ihg978 |
| def45 | ljk60 |
Could you please help to resolve using some sql function or logic?