At 6:57 PM -0800 3/4/2003, Cliff Rediger wrote: > >At 2:33 PM -0300 3/4/2003, Guias Lux wrote: >>>Hello: >>> >>>In FileMaker 4.0 I want to select all the records that begins with a certain >>>letter. How can >>>I do that ?. I iamagine that the answer is very simple but I could not find >>>it. >> >>==c* to search for entries that start with "c" in a FIELD. The only >>way to search a whole record is to set up identical searches in each >>field, one per request. The "==" and "*" and other search criteria >>are listed in the "Symbols" pop up menu on the left side in the find >>mode. > >Clark, >I'm running FM 3.0 so that may say something. But I didn't see the >"--" option in my symbols menu. No worry, when I enter "--c*" as the >search criteria in a field it returns all records that contain a word >in the selected field that begins with "c". That "c" word may appear >anywhere in the text string of the field. > >I sent my solution to the original respondent, but it did't make it >to the PB list. I got this > >Failed to deliver to '<[EMAIL PROTECTED]>' >LIST module(list powerbooks) reports: > Your message cannot be posted. > It has the content-type: multipart/alternative, > and this list accepts plain text only > >Don't know what that is. >Anyway, my FM solution was to create a calulation field that finds >left(text,1) This will give you the first letter of the first word in >that field in every recored. Then search on that calculation field.
It's "==c*", equal sign not hyphen. -- Clark Martin Redwood City, CA, USA Macintosh / Internet Consulting "I'm a designated driver on the Information Super Highway" -- PowerBooks is sponsored by <http://lowendmac.com/> and... Small Dog Electronics http://www.smalldog.com | Enter To Win A | -- Canon PowerShot Digital Cameras start at $299 | Free iBook! | Support Low End Mac <http://lowendmac.com/lists/support.html> PowerBooks list info: <http://lowendmac.com/lists/powerbooks.shtml> --> AOL users, remove "mailto:"; Send list messages to: <mailto:[EMAIL PROTECTED]> To unsubscribe, email: <mailto:[EMAIL PROTECTED]> For digest mode, email: <mailto:[EMAIL PROTECTED]> Subscription questions: <mailto:[EMAIL PROTECTED]> Archive: <http://www.mail-archive.com/powerbooks%40mail.maclaunch.com/> Using a Mac? Free email & more at Applelinks! http://www.applelinks.com
