Since you wrote the program, you should know. My impression is that SQL doesn't handle substrings as well as VB, but I really don't know. I quit programming about the time C++ came out, so there have been a lot of changes since then.
Thanks for the feedback. On Sun, Jan 17, 2010 at 7:26 AM, Dennis M. Kowallek <[email protected]> wrote: > I don't think this is possible in LTools because many of the VB > functions that are available in the MS Access client (like the substring > function) are not available to LTools. I'd be happy to be proven wrong > though. -- Jim Walton "...probe the past carefully and report it as it was, not as I wish it were" >From Evidence Explained by Elizabeth Shown Mills 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 To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp

