select name from daTable
where length(name) =
( select max(length(name)) from daTable )

How about the record that has the most number of words ? I am referring to MYSQL manual now, but still can’t find a solution for this.

SELECT lemma FROM word 
WHERE (LENGTH(lemma)-LENGTH(REPLACE(lemma,' ',''))) = 
(SELECT MAX(LENGTH(lemma)-LENGTH(REPLACE(lemma,' ',''))) FROM word);

There is a new way of doing it since PHP 3.2 after php_mssql.dll got discontinued.
Start by downloading this Microsoft driver for PHP http://sqlsrvphp.codeplex.com. Read readme to determine which file(s) will match your PHP. Next copy those file to your extension folder of your PHP install, and adjust your php.ini by adding or uncommenting those two lines:Read More