LEN(RTRIM(LTRIM(Temp.Link))) -- in MS SQL Server you can get the same result with just LEN(Temp.Link)>Is there a way to adjust this SQL command to be ANSI compliant?
>SELECT Temp.Numero,Temp.Link,Temp.TotalLink,Link.URL,LEN(ALLTRIM(Temp.Link)) AS LenLink > FROM (SELECT MIN(Link.Numero) AS Numero,Link.Link,COUNT(*) AS TotalLink > FROM Link GROUP BY 2) AS Temp > INNER JOIN Link ON Temp.Numero=Link.Numero > ORDER BY LenLink DESC >>