mhudd Posted March 29, 2002 Share Posted March 29, 2002 What kind of script do I use to find all names that begin with a letter of the alphabet? What I want to combine to letters... is it possible? Link to comment Share on other sites More sharing options...
Keith M. Davie Posted March 29, 2002 Share Posted March 29, 2002 "...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. Link to comment Share on other sites More sharing options...
danjacoby Posted March 30, 2002 Share Posted March 30, 2002 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 More sharing options...
glaser_david Posted March 30, 2002 Share Posted March 30, 2002 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 More sharing options...
Keith M. Davie Posted March 30, 2002 Share Posted March 30, 2002 Sorry dan. I made an assumption that he had just one name in his field since he did not specify more than one. Could have been a "last name" field. One can always concatenate. Link to comment Share on other sites More sharing options...
Newbies EagleAdmin Posted April 13, 2002 Newbies Share Posted April 13, 2002 To find Ann Marie and not Mary Ann , perform your find using ==a* Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8048 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 accountSign in
Already have an account? Sign in here.
Sign In Now