Thanks to Dennis for the SQL. I've never used SQL before, so if I have any problems I can contact you off list. In the OP I did say that I know how to change the actual files, so that is no problem.
To Mike, if the extension is TIFF and you want to change it to TIF, the same SQL should work, except change jpe to TIFF and jpg to TIF. If you want to change them to jpg, then you need to change the file internals as well. There are some mass file changers out there. Google "batch file conversion" or maybe someone on the list knows of a good one. Thanks to all for all the advice Regards Tony ======= Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.27, Virus/Spyware Database: 6.18350) http://www.pctools.com/ ======= Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
