>What's a good algorithm for removing numeric information out of text fields or vice versa?
>
>We're getting a lot of file conversions lately and just thought one of you might have a better approach than the "brute force" method I've been using lately.
>
>TIA

Could you be more specific? You are already using VAL() right?