Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: J.J. Castorena
  
 
 
 J.J. Castorena
 Tags
Subject: RE: finding longest name in a field
Thread ID: 22379 Message ID: 22385 # Views: 20 # Ratings: 0
Version: Visual FoxPro 5 Category: Databases, Tables and SQL Server
Date: Wednesday, April 16, 2003 8:56:44 PM         
   


calculate MAX(len(alltr(store_name))), MIN(len(alltr(store_name))) to lnmax, lnmin

> Hello,
>
> 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..


COMPLETE THREAD

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