>
Problem is that the phone number has been declared as numeric and padL might not work.>
>Really? Why? Exactly how many mathemetical computations do you do with telephone numbers < s > ?
>
Yea - beats me Marcia - lol.
>Having said that, PADL() will still work with numeric data, but it has the effect of transforming it into character data.
>
I noticed, but that latter is informative in that it is transformed into a character data. Thanks.
>Also, just an FYI, you can use the STRFILTER function in FoxTools to accomplish the same thing that Nadja an Gerald have showed you with CHRTRAN:
>
>SET LIBRARY TO FOXTOOLS ADDITIVE
>lcNewString = STRFILTER( lcOldString, '0123456789' )
Like Dragan says - must have at least 3 ways to skin a fox. Thank you for those quick lessons:)
- Ravi
True greatness consists in being great in little things.
- Charles Simmons