>I have a character-type field with numbers and dashes in
>it. The dashes are at varying places in each string.
>I want to strip out the dashes (and trim the trailing
>spaces) and then store the resulting stripped
>numeric-only string in another field. How do I do this?
REPLACE somefield with ALLTRIM(STRTRAN(sourcefield, "-",""))
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison