Ed Curtis <[EMAIL PROTECTED]> wrote on 06/22/2005 02:27:02 PM: > I've been cruising the docs for a while now and can't find what I'm > looking for. I know it has soemthing to do with value or LEN or something > easy like that but I just can't find the right command structure.
> I need to list the rows in a table where the length of a field, lets say > field1 is a minimum of 60 characters or larger. The field type is varchar. > Thanks, > Ed You were SO close!!! SELECT <field list> FROM <table references> WHERE CHAR_LENGTH(varcharfield) >= 60; http://dev.mysql.com/doc/mysql/en/string-functions.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine