I have a field that was imported from Excel - I need to compare with another field - the one imported from Excel has dashes and the existing field does not. I know that I can use a trim statement, but I can't get it to work:
here's an example
is: 123-45-6789
needs to be: 123456789
Can anyone help me!
here's an example
is: 123-45-6789
needs to be: 123456789
Can anyone help me!