Unanswered: Problem with update statement please help.
I'm trying to update a field that is set to text.
The variable FixedSSN is set to say "099999999"
The problem is that it is dropping the 0 at the beginning, and setting the field to the value of "99999999" How can I fix this? I want the 0 at the beginning. Here is a copy of the string that I am using.