One more question.  I'm storing phone numbers as a string of text, such as, 9515551212 and searching for this comes up empty.  The index includes 0-9 characters..

Any ideas?

TIA,

John

John


Going on fading memory I think the standard word generator excludes numbers. Even storing as a string it probably thinks a phone number as a string is a number.

Roy Lambert [Team Elevate]

John,

<< One more question.  I'm storing phone numbers as a string of text, such
as, 9515551212 and searching for this comes up empty.  The index includes
0-9 characters..  >>

Hmm, is this the same table ?  If so, I'll check it out here and see what I
can find.

--
Tim Young
Elevate Software
www.elevatesoft.com

Yes, it's the same table.  I added a 'P' char to the end of each number and search using 8885551212* and it works.

Thanks!

john

John


>Yes, it's the same table. I added a 'P' char to the end of each number and search using 8885551212* and it works.

Looks like my guess was right - its being treated as a number. If you're not happy with your solution then you need a custom function to generate the "words" and let numbers through. If you want I think I've still got the one from my DBISAM app and can rip it out and email it to you.

Roy Lambert [Team Elevate]