My SQL Server database input values follow a pattern of where the first position is a character and then followed by number. I want replace the first character with another character or characters . For example:
Potential values for the first position are
I am looking for an option without using multiple
REPLACE statement and not using
If I use
CASE, I will have to check 26 cases or if I use
REPLACE in a nested way, I may end up using 26
REPLACE statements. I am trying to avoid these.
Please suggest any better way to do achieve the results.