Jump to content

Aphabetical script


This topic is 7135 days old. Please don't post here. Open a new topic instead.

Recommended Posts

quote:

Originally posted by Keith M. Davie:

"...to find all names that begin with a letter of the alphabet?"

Use the asterisk (*) wildcard; e.g. to find all names beginning with letter "a" you would enter a* in the field to be searched.

Incorrect. This will find any record in which the letter "a" is followed by another character (I did a search using this, and the name "Mary Ann" was in the found set).

The only way I can think of off the top of my head (and there's not much left on the top of my head) is to create a calc field: Left(Name, 1), and then do a search in that field for the letter "a".

Link to comment
Share on other sites

this will probably work, however in a large database, you don't want to be performing search on unindexed calculation fields.

You could create a script that use the string functions...

You can then set up your serch value in the script, or ask user input during the script.

Link to comment
Share on other sites

  • 2 weeks later...

This topic is 7135 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.