Minimum, Maximum and Average Length of Display Names with spaces removed


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT   max(len(replace(displayName,' ',''))) as maxDisplayNameLength,
         min(len(replace(displayName,' ',''))) as minDisplayNameLength,
         avg(len(replace(displayName,' ',''))) as avgDisplayNameLength
  FROM   Users;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results