Sql Select Len

From: "Jeff" <jhoward@xxxxxxxxxxxx>
Date: Wed, 4 Jun 2008 16:50:07 -0600

Is there a way to select the lengths of text fields using a query and
quickly find the max length?

I currently have SELECT LEN(C1) AS MYLENGTH FROM TABLE1.

The information of all rows is in my result set but without running through
the results I cannot quickly find my largest length. I tried using an order
by clause for C1 but it sorts the data alpanumerically so I cannot simply
go to the last record to pull the largest value!

Thoughts?

.

Follow-Ups:
- Re: Sql Select Len
  - From: Brian Bushay TeamB

Prev by Date: Re: How to monitor sqls executed in ado connections ?
Next by Date: opening a dataset with a missing parameter
Previous by thread: How to monitor sqls executed in ado connections ?
Next by thread: Re: Sql Select Len
Index(es):
- Date
- Thread

Relevant Pages

Segmentation fault
... I have a script about query record from MS Access database. ... When I use the query command: select * from Lengths ... When I use the query command: select * from Lengths where Taxon_ID ...
(perl.dbi.users)
Perl OBDC Segmentation fault
... I have a script about query record from MS Access database. ... When I use the query command: select * from Lengths ... When I use the query command: select * from Lengths where Taxon_ID ...
(perl.beginners)
Perl OBDC Segmentation fault
... I have a script about query record from MS Access database. ... When I use the query command: select * from Lengths ... When I use the query command: select * from Lengths where Taxon_ID ...
(perl.beginners)
making query or table
... I want to make a query or table containing 3 fields. ... but anyway the 3field table/query i'm creating is then going to be used to ... get the over all lengths of each unique color/size combo in the unit name ...
(microsoft.public.access.modulesdaovba)