First Letter Searches

[S. Brooks]

Is there any way to program a search so that it only searches the first letter of each record. For example at the moment when I search for companies beginning with 'I' in my database I get 'Aggregate Industries' because of the 'I' in the second word. Is there anyway to stop this?

Thanks.

[aaa]

Hi, brooks!

Creat calculated field=Left(Your_Text,1) and serch by it.

This is one of ways.

[mz123]

In Find Mode, you can enter the following:

==A*

A being the first letter you are looking for

Hope that helps ???

[S. Brooks]

Thanks for your help, but is there not a way that users can simply enter 'A' and find every result beginning with 'A' instead of results that have 'A' at the start of their second word?

Thanks.

[Genx]

...Im pretty sure that does, but if it doesn't... add an additional unstored calc field, make it leftwords(yourtable::yourfield ; 1) and then search that.

[Lee Smith]

Hi Genx, that was already suggested by aaa.

Hi S. Brooks , and welcome to the Forum.

Upgrade to v8, and use the Auto-Complete, It works in Find Mode.

Do a search of the Forum for Clairvoyant or Typeahead (there are a few workarounds done in versions as early as 3)

Also, search Database Pros Web Site

Prior to v8, I preferred using a script for this attached to buttons, here are a couple example files.

AlphaJump By: Don Wieland URL:

http://www.fmfiles.com/tnt8.html

Alphabet Filter By: John Mark Osborne URL:

http://www.databasepros.com/resources.html

AlphaDex By: The Alchemy Group URL:

http://www.alchemy-group.com/alchemy.html

Lee

Edited August 10, 2006 by Guest