I have found a solution that works for now.  

I have declared a new variable and set a default value on it.

In the the sproc  I set the variable using...

Thanks for your help and advice.

Thank all of you for your replies,  it is helping.

Here is a better look at the entire string.   I am not sure at this time if the substrings are going...