Replace characters in field as a part of a SQL select
Posted on 2011-10-24
I have a table with partnumbers and their descriptions that I need to load into another application.
The problem is that there are some characters in the source description that are invalid in the target application.
What I'd like to do is generate a select statement that creates an output where the description no longer contains the invalid character, however each invalid character has a corresponding valid character.
For example if I have a partnumber description RIB+238^RTD I need to generate an output description in the select which replaces the + with / and the ^ with %.