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

0

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

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached