Dear all,
I want to replace the 3th position of the string by "#".
"abc123" -> "ab#123"
best regards
gab
Printable View
Dear all,
I want to replace the 3th position of the string by "#".
"abc123" -> "ab#123"
best regards
gab
gab,
I think it is realy time for you to grab SQL Reference manual and learn a few basic things about character functions. I've given you a sollution for very simmilar question (on a diferent thread you started under the same title as this sone), however it seems that you don't learn very much from the answers to your questions. If you think others will solve any trivial task you stuck with, you won't get very far in this...
Anyway, the answer to your question is:
SUBSTR('abc123',1,2) || '#' || SUBSTR('abc123',4)
Dear sir,
Thx your answer.