Odin flashing a complete tar file (as opposed to a modem or kernel) will completely rewrite the data on your phone, so it will be set back to stock - you will lose both root and custom recovery. There are also root uninstallers, but I have not seen any other method to remove the custom recovery (and I can't say whether the root uninstall restores everything that was altered in order to root). I Odin flashed my first Epic when the 4G radio died (hardware failure), and it no one at the Sprint store was any the wiser (although, at this store, I probably could have gone in with it running DOS and they wouldn't have known the difference, lol)
Flashing the .tar file as noted above will wipe the slate clean. However, the process doesn't remove the CWM files from your SD card. You will need to delete those manually with a file manager like Astro or Root manager.
Thank you, I plan to format my SD card after I have gone back to stock, so I guess that should take care of any trace files like CWM which would be there in the SD card.
I have the SPH-D700-DI18-8Gb-REL.tar.md5 and s1_odin_20100512.pit which I guess should suffice to Odin back to Stock Eclair. I had used these same files to Odin back from Froyo.