Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: J.J. Castorena
 J.J. Castorena
Subject: finding longest name in a field
Thread ID: 22379 Message ID: 22379 # Views: 0 # Ratings: 0
Version: Visual FoxPro 5 Category: Databases, Tables and SQL Server
Date: Wednesday, April 16, 2003 7:27:26 PM         


I am a novice with FoxPro, but getting much better, thanks to all of you. At no time have I been refused assisitance from you great guys. It's why I study and play with data as much as I can. My question is this. I have a table of 60,000 records. The records contain a field called store_name which is the store name. What I want to do is determine which is the longest store name I have and what is the shortest store name I have. I'm sure it's something easy, but I need to do it so the query returns the records with these store names.

Thank you much..


finding longest name in a field Posted by J.J. Castorena @ 4/16/2003 7:27:26 PM
RE: finding longest name in a field Posted by Yuri Rubinov @ 4/16/2003 8:56:44 PM