sql server

[calithl450]

Hello experts, I would like to ask a question: Is there multiple special character truncation in a string? How to use oracle SQL to intercept multiple special characters in a string? Make them correspond to the corresponding column names? @ -> No.2, # ->No.3, $->No.4

Thank you very much for any help！

[#2]

@calithl450 

---

Is there multiple special character truncation in a string?

---

No, there isn't such a function, even because per se there is no definion of "special characters". For example the dollar sign $ is quite common in finace secor.

You have to implement it on your own.