I need to setup a function that would change any character in a certain field that contains any character from an alternate table. For instance, a field may contain the following:
ABC DEF_GHI%_JKL
I want to setup a function or multiple functions that would replace the space, underscore, and percent all with a dash (ABC-DEF-GHI–JKL).
I currently have a seperate table with the criteria (space, underscore, etc) that I want to replace in an alternate table. I have tried to use both the INSTR function and the REPLACE function, but had multiple problems. One being that when I run the query I get duplicated lines and the other is that it won’t depict the space as a character.
Can someone help?
Thanks,
Drew