Is there some clever uses of the existing string functions to do something like this? Or do I need a UDF?
Say I'm concatenting two strings, str1 and str2. str1 is a series of letters in alphabetical order. str2 is a single letter.
For example, str1 = 'ACHT' and str2= 'P'.
Is there a way to combine str1 and str2 so that the resulting string keeps the letters in order. So in this case, the result will be 'ACHPT'.
View Complete Post