Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Promoted
Need help with Foxpro function?
I need to inseert a character into a character string. Example: I have 1234567890 and I need to return 123-456-7890
Anyone know the correct funtion for this? Please and thank you!
2 Answers
Relevance
- Anonymous1 decade agoFavorite Answer
- 1 decade ago
Try this
LEFT(<phoneno>, 3) + "-" + STREXTRACT(<phoneno>, 4, 7) + "-" RIGHT(<phoneno>,4)
Source(s): I was using Foxpro long time ago
Still have questions? Get your answers by asking now.