I dunno about ANSI compliance but for VFP and MS SQL Server you can use

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
>

>
>The problem is with the alltrim command.