1. snow12 New Member

   Hello:
   I have a field colum whose type is varchar. How to find which row has the max length of character in this field column?
   Thanks,
   Snow
   

   snow12, Apr 29, 2008

   #2
2. Luis Martin Moderator

   select max(LEN(charfield)) as maxchar from yourtable
   

   Luis Martin, Apr 29, 2008

   #3
3. snow12 New Member

   Hi, Louis
   Thanks for the help. I got maxchar: 500, but I would like to know which row has this max character field. How to do it?
   Thanks,
   Snow
   

   snow12, Apr 29, 2008

   #4
4. Luis Martin Moderator

   Try something like:
   SELECT max(len(charfield)) as maxchar ,
   (SELECT COUNT(*) FROM yourtable) AS rownumber
   from yourtable
   

   Luis Martin, Apr 29, 2008

   #5
5. Madhivanan Moderator

   Also try
   select * from yourtable where LEN(charfield)=(select max(LEN(charfield)) as maxchar from yourtable)
   

   Madhivanan, Apr 30, 2008

   #6

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in