2005/9/20, Jens-Peter C. Hillers <[EMAIL PROTECTED]>: > > May be true for 32, but for 2000 ?? > so take the middle ! were talking about 64K. I'll think some Megabytes are > your Problem ! > or use select count(*)*avg(length(YourVarcharField)) from t1
select sum(length(YourVarcharField)) from t1 where userid = 1234 is much simpler regards robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]