I have a string that comes through as follows
A24+B34.56* or sometimes comes through like this A24 or B34.78
I would like to check the string in my stored procedure.
If there is a + sign in the string I want to split the string into 2 values using the plus sign as the delimiter.
If there is no plus sign I would just like to use the value as it comes.