Find All Companies that begin with the letter.....

[ChuckO]

I have a field called CompanyName. I'm trying to write a script so that I can find all Records that begin with a certain letter. All I've been able to figure out is to do a Find on words that begin with a certain letter. If I do that, the company ABC Cans will appear in a search for A and C. Is there a way to do a search based on the first letter (of the first word)of a company name?

[Jazz]

In the find field type "==a*" (without the quotes) to find all starting with 'a'. The "==" says do an exact match (but case insensitive), and the "a*" says 'a' followed by anything.

John

[Lee Smith]

Hi Chuck,

I have adapted a file by Don Wieland called AlphaJump that does this pretty good, and there is a very similar file called Alphabet Filter by John Mark Osborne.

These files can be downloaded directly form their sites:

"AlphaJump" at www.dwdataconcepts.com

"Alphabet Filter" www.databasepros.com

HTH

Lee

[jasonwood]

I haven't used wildcards much so I could be wrong, but I seem to recall that they take extra time to find...

You might also consider adding a new calculation field that is simply = Left(CompanyName, 1)

This field will contain the first letter of the company name, so you can simply perform a find in this field.